Viewing 15 posts - 2,146 through 2,160 (of 3,221 total)
Please note the valid comment below by GilaMonster Posted Today @ 11:33 AM Gail Shaw thank you for bringing my oversight out into the light.
Why use a trigger, you...
January 31, 2010 at 8:49 am
Finally .... but can I ask why do you want to find the SP that "is using it"
Indexes are not used by SP's rather are used by the Query optimizer...
January 30, 2010 at 8:27 pm
I believe this might be of assistance to you
SQL Server 2005 Books Online (November 2008)
sys.dm_db_index_usage_stats
http://msdn.microsoft.com/en-us/library/ms188755(SQL.90).aspx
It will give you Returns counts of different types of index operations and the time each...
January 30, 2010 at 5:28 pm
Your question is rather vague. Do you mean stored procedures (SP) using a query hint? Or those that reference in a WHERE clause a column of a...
January 30, 2010 at 5:03 pm
Lynn Pettis
is said that you are never more than 6 persons removed from every other person on this earth
Always thought that was a fallacy - what I...
January 30, 2010 at 3:28 pm
malleswarareddy_m The question is improper
Rick-153145 Another rubbish QoTD.
bluesbiker I agree with user "malleswarareddy_m", this question is improper
To malleswarareddy_m, Rick-153145 and bluesbiker let me issue you a challenge....
January 29, 2010 at 7:32 am
Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'SELECT'.
Msg 102, Level 15, State 1, Line 8
Incorrect syntax near '.'.
Corrected the code in my original answer
Sorry...
January 28, 2010 at 12:45 pm
jadonr
You could use a modification of Lowell code in an UPDATE statement
For example:
UPDATE IM_PRC SET PRC_1 =
CASE
...
January 28, 2010 at 11:36 am
Lynn Pettis (1/27/2010)
--------------------------------------------------------------------------------
Is my halo getting tarnished by such responses as this?
Lynn Pettis today
Of course you'd probably know most of this if you were to take some time and...
January 27, 2010 at 11:37 am
Start here:
SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME ='testTable' AND COLUMN_NAME = 'tinfo'
which in your case returns: varchar and fold the code to determine the column type into...
January 26, 2010 at 2:11 pm
Ran your code using my SQL Server 2005 and got the following error messages.
Msg 207, Level 16, State 1, Line 6
Invalid column name 'DepartmentID'.
Msg 207, Level 16, State 1, Line...
January 26, 2010 at 1:32 pm
Having been a newbie, and posting bone headed questions in the past, this one really got to me
Thanks, but that doesn't really help me at all. I think that I...
January 25, 2010 at 2:37 pm
bgsxygrmn
Thanks, but that doesn't really help me at all. I think that I would have to combine two of the functions that are listed in the link.
Do not understand...
January 25, 2010 at 2:24 pm
Go here I am sure you can find what you need.
https://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/03/25/some-common-date-routines.aspx
January 25, 2010 at 1:33 pm
Viewing 15 posts - 2,146 through 2,160 (of 3,221 total)