Viewing 15 posts - 49,411 through 49,425 (of 59,078 total)
Melville (7/5/2008)
As to Mr. Moden's 'why' - I think that the answer is that sometimes you want a specified but user variable number of rows returned -
Heh... lordy... I...
July 5, 2008 at 1:58 pm
rbarryyoung (7/5/2008)
Secondly, to do anything with...
July 5, 2008 at 1:10 pm
dakshinamurthy (7/5/2008)
I would also helpfull if i get to know what to do if we exceed the seed value for a bigint field in a table
If you exceed the maximum...
July 5, 2008 at 1:04 pm
BitBucket... I like your signature line... I think everyone should have that line in it... 😉
July 5, 2008 at 12:58 pm
Ooooohhh! Be real careful... unless all of your dates have a midnight time, the following will miss all but the first millisecond of the date carried by @friday...
select *...
July 5, 2008 at 12:27 pm
Of course, the real question is...
What have you written a CLR for that you think can't be done in T-SQL?
Seriously... several of us have had several major "races"...
July 5, 2008 at 9:41 am
Looks like Carl beat me to the notation about formatting being done on the client side...
Carl... no, I don't have the link that you're asking about... sorry.
July 5, 2008 at 9:37 am
b_boy...
Along with what Mouse suggested, lookup CONVERT in Books Online to find all of the built-in date patterns. It's worth the read.
As a side bar, if there's a GUI...
July 5, 2008 at 9:36 am
Carl Federl (7/5/2008)
July 5, 2008 at 9:28 am
Talib Khan (7/5/2008)
July 5, 2008 at 9:09 am
In the meantime, why don't you just go ahead and tell us what the solution is 😉
July 4, 2008 at 10:13 pm
I don't believe there's anything in SQL Server that will import such a thing... does it have any export capabilities, say, to a CSV or fixed field text file?
July 4, 2008 at 10:08 pm
The trigger fires just fine... the UPDATE is the problem... or rather the data, data order, and criteria for the update is the problem... This never qualifies with the...
July 4, 2008 at 9:46 pm
Actually.... I want to see both the trigger and the proc... it would also be nice if you'd post the Create statements for the table being deleted from and any...
July 4, 2008 at 9:14 pm
ywb (7/4/2008)
It does. Thanks!
Two way street... I'm always curious about these type of things...
Why do you need to do this, please?
July 4, 2008 at 9:09 pm
Viewing 15 posts - 49,411 through 49,425 (of 59,078 total)