Viewing 15 posts - 31 through 45 (of 253 total)
I don't think you are allowed to backup the tempdb. If you made some customizations to it I think you have to do those manually. msdb will port your jobs....
March 30, 2005 at 8:37 am
Thanks for the input. In our case the files are actually there. For example, we have hourly log appends and one hour it may fail, and the next it may...
March 30, 2005 at 7:21 am
Depending upon how often you use this, and whether you do a SELECT * from the table very often without needing this merged value, you may want to consider creating...
March 23, 2005 at 11:18 am
I'll join the fun. In all examples I've seen so far they leave a trailing space if the suffix is NULL. Also, all that I've seen so far will not...
March 23, 2005 at 8:58 am
When you choose "Debug", you need to wait a while for the debugger to load the session. It takes about 10-20 seconds for some reason on my system. When it...
March 21, 2005 at 6:07 pm
I doubt it. Try the following to see if making your code reflect these examples more closely helps.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adosql/adoprg02_525v.asp
I've never used output parameters like this, but it may be...
March 21, 2005 at 1:55 pm
I could be wrong, but it seems to me that if the problem were an unknown constant he would be getting runtime errors instead of just an empty output parameter...
March 21, 2005 at 8:29 am
Not really. Technically it doesn't need a SP, it just needs the ability to run a SQL batch so that the two step process will work. The only way I...
March 15, 2005 at 9:30 am
This is fairly simple if you are only after one ColA value. The following assumes @ColA as an input parameter to a stored procedure.
declare @MergedColH varchar(1000)
set @MergedColH = '' --...
March 15, 2005 at 8:34 am
I couldn't help but do some more research on this. Using 4 different tables I put together various queries. SQL Server is actually more aggressive on its optimization than I...
March 4, 2005 at 8:40 am
I'm going to say the former based on the following. If it only exists in table2 SQL Server should know enough in the first method to not even bother looking...
March 3, 2005 at 2:36 pm
SELECT account_number
FROM table1
WHERE inactive_flag = 1
AND (
EXISTS ( SELECT table2.account_number FROM table2 WHERE table2.account_number = table1.account_number )
OR EXISTS ( SELECT table3.account_number FROM table3...
March 3, 2005 at 2:13 pm
I've never worked with ColdFusion so I can't do more than theorize here. But first of all, I have assumed that you are using varchar versus nvarchar. nvarchar and nchar...
March 3, 2005 at 12:01 pm
There are ASCII versions of them that apparently the UNICODE() function translates into the codes you listed.
Ascii values = (147)(148)(32)(145)(146)
It is ultimately a matter of character mapping from UNICODE to...
March 3, 2005 at 11:15 am
First of all, the error suggests that you have more than one column listed in the SELECT portion instead of just the "1" constant value you posted. You may want to...
March 3, 2005 at 9:05 am
Viewing 15 posts - 31 through 45 (of 253 total)