Viewing 15 posts - 481 through 495 (of 1,315 total)
You could right-click on the view in the object browser and select Edit...the resulting script should be an ALTER VIEW script with the correct schema name. It would require at...
June 1, 2007 at 7:53 pm
How about this:
If IsNumeric(DTSSource("Col004")) Then
DTSDestination("TTLCrd") = CInt(DTSSource("Col004"))
Else
DTSDestination("TTLCrd") = 0
End If
June 1, 2007 at 5:47 pm
Does the last line of your format file have a trailing CR/LF? Since it is complaining about the last field of the last line, I think this might be the...
June 1, 2007 at 5:37 pm
Any electric motor has instant full torque, this is not unique to the Prius. But full torque is the worst possible way to try to start on snow or ice, kind...
May 30, 2007 at 2:54 pm
If you do a lot of stop-and-go driving, hybrids have a huge advantage because they can use regenerative braking to put some of the energy you've paid for back in...
May 30, 2007 at 12:50 pm
Switch to Text results with ctrl-T, then execute "SELECT text FROM syscomments WHERE ID = OBJECT_ID('your_procedure') ORDER BY colid". You should get the original CREATE PROCEDURE text as a result.
May 30, 2007 at 12:16 pm
LIKE only handles a small set of wildcards, it is definately not a full-blown regular expression operator.
The most robust way to do it is the solution you already found, "select...
May 30, 2007 at 11:32 am
You might step out of the T-SQL world for a minute and consider doing something with SMO or DMO in Visual Basic, C#, or your language of choice. There are...
May 30, 2007 at 11:20 am
You "get around the SP problem" by realizing that the SPs are going away and you have to learn how to work with the new SSIS-based maintenance plans. You build...
May 23, 2007 at 3:49 pm
The minimum permissions would be db_datawriter for deletes and updates, and db_ddladmin for truncates. Or you can create remove all access to the tables and only grant execute permissions to...
May 15, 2007 at 9:11 am
Differential backups don't replace log backups, but they can allow faster recovery and limit the number of log backup files you must retain.
One possible plan would be weekly full backup on...
May 14, 2007 at 5:30 pm
The "CPnnn" part of the name is the Code Page specification. "CP1" is short for code page 1252 (standard for US English), other code pages have to be fully specified.
See...
May 14, 2007 at 5:16 pm
The ROUND function can also truncate. ROUND(@num, 4, 1) will do the job without the extra scaling.
ROUND(99.021377000, 4
May 14, 2007 at 4:51 pm
The problem with the Enterprise Manager generated script is that there is no error checking. It always drops the table, whether rows were copied or not. I either execute it...
May 11, 2007 at 10:38 am
Viewing 15 posts - 481 through 495 (of 1,315 total)