Viewing 15 posts - 5,971 through 5,985 (of 7,636 total)
Steve Jones - Editor (8/10/2008)
I'd recommend select * from information_schema.routines
Oh yeah, I forgot about this one. I like it much better.
August 10, 2008 at 6:56 pm
Jeffrey Williams (8/10/2008)
Well, according to BOL - no, you don't have to update usage.
Hmm, yeah I see where it says that Jeff. I may be wrong here, when I...
August 10, 2008 at 2:13 pm
Jeff Moden (8/10/2008)
rbarryyoung (8/10/2008)
Gimme time to eat lunch, Jeff! 😛 🙂Heh... hey! I need to know... does brother Darth have to take off the Chevy look-alike to eat?
Straws....
August 10, 2008 at 11:17 am
Jeff Moden (8/10/2008)
Again, I ask... do you have to update usage for the rowcounts to be accurate?
Gimme time to eat lunch, Jeff! 😛
Yes, you do. But unless...
August 10, 2008 at 11:03 am
Now this view can get the estimated row counts (and a lot more besides)without cursors: http://www.sqlservercentral.com/scripts/tables/62545/
August 10, 2008 at 10:27 am
Actually, you DID get an answer at your original post.
August 10, 2008 at 6:40 am
Mscode_Pro (8/10/2008)
The table is not exist in Master Tables, and if it exists what the structure of it to make the query works???
It must exist in MASTER or else you...
August 10, 2008 at 6:21 am
Try this:
CREATE TRIGGER mytrigger ON mytable
AFTER UPDATE AS
Declare @UpdateBits int
Declare @Mask9to18 int--set mask for bits 9 to 18
Set @Mask9to18 = 512|1024|2048|4096|8192|16384|32768|65536|131072|262144
Set @UpdateBits = Cast(COLUMNS_UPDATED() as int) & @Mask9to18
IF @UpdateBits >...
August 9, 2008 at 10:35 pm
and i want to know why the master database make it works?????????
Because Emp_Inf table is defined differently in MASTER than is is in your other database(s).
August 9, 2008 at 9:29 pm
shamshad.ali (8/9/2008)
The problem is I have to "Find DISTINCT SPECIAL characters in column [NTLogin]"
The problem is that "DISTINCT SPECIAL" does not really mean anything. What you call special is...
August 9, 2008 at 9:36 am
mstrong86 (8/9/2008)
Another thing to keep in mind is that not all cursors are bad- it's possible that they are the appropriate tools to use for the task at hand.
No, they're...
August 9, 2008 at 9:23 am
Like this:
INSERT INTO FooTable (Col_X, Col_Y, Col_Z)
SELECT Expression_1, Expression_2, Expression_3
FROM FooTable
WHERE SomeCondition_A
AND SomeCondition_B
August 9, 2008 at 7:54 am
By its very nature, SQL Server does not share well, especially memory. If you need it to leave space for IIS, then you will need to limit SQL Servers...
August 9, 2008 at 6:50 am
Atif:
These does not conform to the rulesfor Haiku. Haiku are supposed to consist of 3 lines, with 5 syllables in the first line, 7 syllables in the second...
August 9, 2008 at 5:54 am
Viewing 15 posts - 5,971 through 5,985 (of 7,636 total)