Viewing 15 posts - 316 through 330 (of 5,356 total)
No - to which one Frank ?
Did you ask more than one question in that posting?
May 12, 2005 at 7:26 am
How are rows inserted into that table? If this happens via a stored procedure, I would set the time there to midnight. Another option would be a trigger that runs...
May 12, 2005 at 7:05 am
Once one has deleted more than one wanted to, I could think of many good reasons. Especially in dynamic environments
Actually I think the only reason is,...
May 12, 2005 at 6:24 am
DELETE only works on one table at a time.
And I think there are some very good reasons for this.
May 12, 2005 at 5:57 am
Can you post an example where this will work?
May 12, 2005 at 3:55 am
Please refrain from posting the same question to multiple fora here.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=181560
May 12, 2005 at 3:28 am
Are you really looking for 90 days or are you looking for 3 months? Just in case you're looking for the latter, subtracting 90 days is not always exact. That's...
May 12, 2005 at 3:12 am
You know, that you're here in the realm of undocumented features? As far as I can tell, you're better off using an available product on the market for reading the...
May 12, 2005 at 3:05 am
See if this helps: http://www.markallison.co.uk/articles/filegrowths.html
May 12, 2005 at 2:33 am
I find this to be a very good explanation on (NOT) IN
http://groups.google.de/group/microsoft.public.sqlserver.programming/messages/f86de13e0ed65a37,f530df34d5afe639,a949c9fe8a01348d,f9b7f14b6b3404a8,66e54e687a069137,e96cf1972f400ad9?hl=de&thread_id=1c12caa50923d3d5&mode=thread&noheader=1&_done=%2Fgroup%2Fmicrosoft.public.sqlserver.programming%2Fbrowse_frm%2Fthread%2F1c12caa50923d3d5%2Fe96cf1972f400ad9%3Fhl%3Dde%26lr%3D%26ie%3DUTF-8%26rnum%3D48%26prev%3D%2Fgroups%3Fq%3Dsql%2Bserver%2Bdifference%2Bnot%2Bin%2Bnot%2Bexists%26start%3D40%26hl%3Dde%26lr%3D%26ie%3DUTF-8%26selm%3Dumy7hwRaBHA.1916%2540tkmsftngp05%26rnum%3D48%26#doc_f530df34d5afe639
May 12, 2005 at 2:26 am
BTW, Frank: I hear the weather in Germany in 2003 was extraordinary and reviewers are calling 2003 the best German vintage since the 1500's!! I'll drink a toast to you...
May 12, 2005 at 2:18 am
Nah, that way I can increase postcount even more quickly
May 11, 2005 at 8:53 am
Does your table contain NULL values in that column?
May 11, 2005 at 8:51 am
Alternatively you can use this:
alter table yourtable
add InsertDate datetime default getdate()
go
May 11, 2005 at 8:45 am
Viewing 15 posts - 316 through 330 (of 5,356 total)