Viewing 15 posts - 46 through 60 (of 1,109 total)
kumar99ms (8/20/2008)
Query to delete, all the records from a table before half an hour,…Delete * from table where condition=100 and …..what we have write here…for time…
Regards,
What is the schema...
August 20, 2008 at 4:58 am
jon (8/20/2008)
Hi Andras,Thanks for e quick reply =)
Shall check MS site for bug patches then 😉
Cheers,
Jon
The bug is at https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=362597
Regards,
Andras
August 20, 2008 at 2:51 am
shree (8/19/2008)
but when issue restore header only command it gave the below error
Server: Msg...
August 20, 2008 at 2:48 am
johan.frisell (8/20/2008)
I want to reada textfile which will further on be used in a mail sent from the database.
To read this file i want to use the OPENROWSET(BULK..) command....
August 20, 2008 at 2:35 am
jon (8/20/2008)
Can anyone tell me if SQL Server Management Studio 2005 have anything similar to VS "devenv /resetsettings" cmd??
Because I want back the default alert box that tells you that...
August 20, 2008 at 2:32 am
shree (8/19/2008)
what might be the reason for this error before that i need to say this back up file we are getting from outside vendor
Please provide possible reasons
it...
August 19, 2008 at 9:12 am
jskvirsky (8/19/2008)
Is there limit to enter data to the table? How many rows can we have in a table and what to do if it reaches the limit? Thank you
No...
August 19, 2008 at 8:52 am
August 19, 2008 at 5:16 am
adnaan.afzal (8/19/2008)
I need to place SET DATEFIRST 1
in a view I am creating as I am based in the UK, where Monday is the start of the week.
I am...
August 19, 2008 at 5:16 am
The datetime data type stores time with the date, so instead of "T_Customers.[Regdate] = GETDATE()-31"
you may want to do something like:
DATEDIFF(day,getdate(), T_Customers.[Regdate]) = -31
Regards,
Andras
August 19, 2008 at 5:02 am
Another thing that you may want to handle (although it does not result in an a syntax error), is multiple updates. When more than a single row is affected, your...
August 13, 2008 at 2:02 am
When you assign a value to a variable you need to use either a SET or SELECT command. So you should have something like:
SET @intFrequency = (@intFrequency * @i)
instead of...
August 13, 2008 at 1:59 am
sqlindia (8/12/2008)
Hi AllI want to list out columns name of SP into a table. They can be dynamic.
Thank in advance
sonny
Could you give an example of what you mean?
Regards,
...
August 12, 2008 at 4:20 am
vinu (8/12/2008)
What you have told is correct but if we are taking both the backups in the same folder will it wont...
August 12, 2008 at 2:15 am
vinu (8/12/2008)
Can anyone tell me why we need to take the Full and Differential backups on separate instead of same folder.
What are the disadvantages if we take...
August 12, 2008 at 1:38 am
Viewing 15 posts - 46 through 60 (of 1,109 total)