|
|
|
July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Missing name type for name entity Posted by geewakaria NO[at]SPAM gmail.com at 5/29/2006 7:07:13 AM Hi,
I keep getting this error whenever I try to describe any of the
entities in my database using their given name:
Missing name type for name entity in phrasing.
I'd like to know the exact cause of this problem, though I think my
biggest question is: what is a "name type"?
Any help wi...more >>
Special Character Posted by dtatham at 5/24/2006 1:04:01 PM Is there anyway to query out the special character ' i.e. foot. We have a
table in a database that has data in it containing the foot and inch
characters. We need to remove these and I can find using 'like' with the "
inch but can't with the ' foot....more >>
selecting colunm with a space '' Posted by stephanie at 5/21/2006 9:07:02 PM When I submit a sql :
select * from view from column=''
the view is pointing to oracle table with ole db provider for oracle
In mssql2000, the result return rows which containing a space ' '
However, in mssql2005, the result return no rows .
Any advise on it?
...more >>
select date list Posted by DavidBsaibes at 5/15/2006 7:58:02 AM i am trying to write a query in sql server 2000 that returns the list of days
between two dates.
it should return something similar to
for i = 1 to 100
select getdate() + i
next i
how can SQL server do such query.
thanks...more >>
UPDATE TABLE1 ONLY WHEN ALL RECORDS IN COLUMN IN TABLE2 ARE TRUE Posted by EdwardH at 5/14/2006 4:59:02 AM Table2 has multiple records joined to single record in Table1. I want to
UPDATE column in Table1 only if all joined records in Table2 are True.
Help would much apprec....more >>
Last order date for each customer Posted by chas2006 at 5/8/2006 9:32:01 AM I would like to write a select statement in query analyzer which would return
the last order number per customer given a specific order type. (Which would
be 1 record per customer) Thanks....more >>
Help on : Could not find stored procedure 'recurse_oids' Posted by dondiego at 5/8/2006 6:11:02 AM Hello everyone,
I'm on MS SQL SERVER 2000.
When runing this simple delete statement:
delete from sd50.cdm_locations where loc_oid =146836832983830528
I get the following error:
Server: Msg 2812, Level 16, State 62, Line 15
Could not find stored procedure 'recurse_oids'.
The state...more >>
How to keep a log register after rollback transaction? Posted by Santiago Sanz at 5/3/2006 4:48:02 AM Hello!
I have this transaction:
BEGIN TRANSACTION
INSERT INTO logs (message) VALUES ('SQL will inserts a new register')
INSERT INTO products (id, name) VALUES (1, 'book')
IF @@ERROR <> 0
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|
| home · blog · groups | Questions? Comments? Contact the dn |