|
|
|
January 2003 March 2003 April 2003 May 2003 June 2003 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 April 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 How many rows exist in these two tables. Posted by Tony Johansson at 7/2/2005 11:45:40 PM Hello Experts!
The question that I want to have an answer to is how many rows does the
Person table have and how many rows does table Car have. No matter if the
Persons own a car or not and the same if the car have a owner or not.
As an aid to be able to answer the question is some select ...more >>
Problem with a job Posted by Mark at 7/2/2005 2:10:44 PM Hi - I have a really simple job I want to run:
BACKUP DATABASE dbusers TO DISK =
"D:\SQLServerBackups\users\dbusers.bak"
...but it fails. There is nothing in the EM log files - is there
somewhere else (other logs) which will let me know why it's failing? Is
there a SQL Server Agent ID tha...more >>
SELECT, INSERT, UPDATE Posted by erncelen at 7/2/2005 9:47:02 AM A douby that arise....
I'm buiding a series of SQL statement (SELECT, UPDATE and INSERT) comparing
table....
e.g.:
UPDATE ztemp SET tables=z.tables, colors=z.colors
FROM z as z
INNER join ztemp as zt
ON z.ID = zt.ID
(ID, tables, colors are column)
ID is primary key...
But I have ...more >>
using Identity property Posted by anoop at 7/2/2005 8:48:03 AM Hello,
please give me the syntax to add or drop the Identity property for
a column in a table using Alter table statement.
Is the syntax
different for SQL Server 7.0 and SQL Server 2000
...more >>
Problem With Stored Procedure Posted by Wayne Wengert at 7/2/2005 6:28:07 AM When I execute the stored procedue shown below it never returns any values?
Howevber, if I execute the Select portion in QA and plug in the value for
@eventlist and set @gemus to 1, it returns the correct 2 email addresses but
when I Execute the SP from QA and use those values I get nothing?
...more >>
Server: Msg 2627, ...Violation of PRIMARY KEY constraint Posted by erncelen at 7/2/2005 3:52:01 AM When I try to update a table I receive the following message
Server: Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_BP_STEP_LINKS'. Cannot insert
duplicate key in object 'BP_STEP_LINKS'.
The statement has been terminated.
I have set NOCHECK CONSTRAINT ALL bef...more >>
Incorrect syntax near '+'! Posted by Arpan at 7/2/2005 2:16:30 AM What's wrong with the following code?
EXEC xp_sendmail
@recipients='a@b.com',
@copy_recipients='a@c.com;a@d.com;a@e.com',
@subject='SQL Server Report!',
@message='Report generated on' + CAST(GETDATE() AS varchar(50)) + '!',
@query='SELECT * FROM INFORMATION_SCHEMA.TABLES',
@attach_res...more >>
SQL Server's Data can be replicated to MSDE 2000 ? Posted by Harsha Shah at 7/2/2005 12:00:00 AM Hello,
I have SQL Server 2000 on window Server 2003, I have a laptop client with
Win XP , I want to install MSDE 2000 on this client and keep weekly updated
with Server. Is it possible ,
If yes, How ?
or any other alternate.
Any hint will be sincerly appreciated..
Harsha.
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Deploy VB.Net application with SQL Database Posted by Harsha Shah at 7/2/2005 12:00:00 AM Hello,
I have an application with SQL data. I want to deploy this application with
data. How can I ????
Harsha
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |