Viewing 15 posts - 1,096 through 1,110 (of 1,162 total)
It's going to be difficult for people to help if the query posted doesn't bear any resemblance to the query you're having problems with.
So, the real query uses a...
November 19, 2009 at 2:32 am
You don't need to use dynamic sql. The easiest way to do this would be to have two select statements and an if else to decide which one to run....
November 3, 2009 at 6:13 am
Maybe I misunderstood the OP, but I thought the expected output was a datetime with seconds and milliseconds stripped off, which is what my first post gives isn't it?
October 28, 2009 at 7:22 am
select convert(datetime,convert(char,getdate(),100))
October 28, 2009 at 6:43 am
The SQL is parsed before it evaluates the conditions of the IF statement, so you'll need to use dynamic SQL for this, which won't be evaluated until the statement is...
October 27, 2009 at 5:59 am
The maximum size of a row in SQL Server is 8KB, so all the columns added together must not exceed this.
The way that varchar(max) gets around this restriction is that...
October 23, 2009 at 7:00 am
Not quite. If you can guarantee that you will not need to store values greater than 8000 chars, then go for a varchar with a fixed maximum length (of the...
October 23, 2009 at 6:38 am
I'd suggest either creating a format file for the BCP command, or as this is SQL 2005, use SSIS which is more user friendly (you can just use the...
October 22, 2009 at 2:17 am
If you can recreate the text file, try using yyyy-mm-dd (e.g. 2009-10-21). What regional settings does your client have? I would assume that date types that include abbreviated English month...
October 21, 2009 at 10:13 am
Some char to datetime implicit conversions are dependent on the Windows regional settings on the SQL Server. What date format are you using in the file?
October 21, 2009 at 9:58 am
I thought the issue was with a recovery after reboot, not recovery after restore?
It was my understanding that regardless of recovery interval, the data files are not written to until...
October 21, 2009 at 9:47 am
Well if you really need a hack (and it is a hack), you can map a drive under the context of the local system account by using xp_cmdshell and net...
October 16, 2009 at 1:48 am
PP-564103 (10/15/2009)
BrainMan (10/14/2009)
October 15, 2009 at 6:32 am
It's a compatibility mode, not an emulation. It's designed to make sure that any functionality that has been deprecated in 2008 is still supported when in 2005 mode, so applications...
October 9, 2009 at 10:20 am
Are there always exactly two records seperated by a comma? If so, you could use something like this:
select a.*
from TableA a
inner...
October 9, 2009 at 7:37 am
Viewing 15 posts - 1,096 through 1,110 (of 1,162 total)