Viewing 15 posts - 916 through 930 (of 3,221 total)
This might work for you
SELECT CONVERT(VARCHAR(8),GETDATE()-1,112)
Result:
20111023
October 24, 2011 at 4:26 pm
Have you read the entry in Books On Line (SQL help file) for the item
sp_executesql (Transact-SQL) It has multiple examples of T-SQL code to accomplish what I think...
October 24, 2011 at 8:35 am
Suggest you start your search by reading this:
http://msdn.microsoft.com/en-us/library/ms190639(v=SQL.100).aspx
and then read: (Written by Brad McGehee)
http://www.sql-server-performance.com/2007/clustered-indexes/
October 24, 2011 at 8:21 am
Read this article
http://sqlblog.com/blogs/kalen_delaney/archive/2007/11/21/cloning-in-sql-server-2005.aspx
It contains detailed step by step instructions on how to do what you want to do
October 24, 2011 at 5:45 am
A couple of questions.
1. Does the input and text boxes have INPUT MASKS associated with them? If yes are they configured the same?
2. Does the SP...
October 23, 2011 at 6:32 am
sqlguy-736318 (10/22/2011)
October 22, 2011 at 12:49 pm
sqlguy-736318 (10/22/2011)
October 22, 2011 at 12:08 pm
sqlguy-736318 (10/21/2011)
Basically when you create a temp table as part of a T/SQL script you have to first...
October 22, 2011 at 8:04 am
Keep in mind that UNIX and DOS do NOT use the same characters for end of line and end of file.
This might help
http://www.brandonhutchinson.com/DOS_and_UNIX_end-of-line_characters.html
October 21, 2011 at 2:15 pm
kstjacques (10/21/2011)
I am using a backup solution (will remain nameless) that fails if a tlog backup is triggered during a full or a diff. This...
October 21, 2011 at 1:53 pm
If this is not a home work assignment, my fee for supplying what you requested is 60.00 U.S. Dollars, with a minimum of $300.00. If it is a homework...
October 19, 2011 at 4:17 pm
To prepare for moving to 2008 may I suggest you read up on the MERGE statement to determine if it will satisfy your requiements.
October 19, 2011 at 9:56 am
Viewing 15 posts - 916 through 930 (of 3,221 total)