Viewing 15 posts - 26,896 through 26,910 (of 49,552 total)
Forget the error for now. (SQL doesn't have an ELSEIF keyword, it doesn't use the THEN keyword in IF..ELSE and there's no Updated table, just inserted and deleted)
If you want...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 4, 2011 at 3:56 am
You need to write the trigger in a set-based way. Assigning variables from inserted or deleted in a trigger is almost a guarantee that the trigger will fail to work...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 4, 2011 at 2:49 am
Ivan Mohapatra (4/4/2011)
i replied to that person as there is no user-id and password for window...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 4, 2011 at 2:29 am
zorbonjo (4/4/2011)
DECLARE @Count INT;SELECT @Count = (SELECT ItemCount from Deleted)
What's going to happen if there is more than one row in the Deleted table?
The correct one.
As long as one and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 4, 2011 at 2:12 am
Please note: 2 year old thread.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 3, 2011 at 11:30 pm
Sure, easy query.
SELECT DB_NAME(database_id) AS DatabaseName, name AS LogicalFileName, physical_name AS PhysicalFileName
FROM sys.master_files AS mf
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 3, 2011 at 11:28 pm
They're in master.
You can get usernames from sys.server_principals, you can get the hashed passwords from sys.sql_logins (I think) but there's no way to get the plaintext passwords. SQL doesn't store...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 3, 2011 at 10:37 am
Jeff Moden (4/3/2011)
GilaMonster (4/3/2011)
Please note: 3 year old thread.It doesn't matter on such timeless subjects.
I post those as a notification as to the original age so that people don't start...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 3, 2011 at 10:34 am
Please note: 3 year old thread.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 3, 2011 at 4:44 am
Why?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 1, 2011 at 6:09 pm
Jeff Moden (4/1/2011)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 1, 2011 at 6:03 pm
Roy Ernest (4/1/2011)
I have not been to the Doctor. I will probably go in the noon.
Go. Rather safe than ...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 1, 2011 at 10:41 am
Roy Ernest (4/1/2011)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 1, 2011 at 10:30 am
WayneS (4/1/2011)
Where is the MVP list of recent awardees? (I'm not gonna get burned today - I'll verify it first!)
There isn't an official one. MS is not allowed to post...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 1, 2011 at 10:26 am
If by 'each and every' you mean a cursor or a row-by-row comparison, no.
Look up EXISTS (and IN) and it should become clear how they work. If you need further...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 1, 2011 at 6:24 am
Viewing 15 posts - 26,896 through 26,910 (of 49,552 total)