Viewing 15 posts - 10,891 through 10,905 (of 13,462 total)
I will add the obvious:
As you spend more time here, you'll see a lot of posts that help people get away from "procedural" Row By Agonizing Row Processing to Set...
July 5, 2009 at 6:37 am
service packs are cumulative...so everything that was in SP1 is also in SP2, and everything that was in SP1 and SP2 exists in Service pack 3, so you only need...
July 3, 2009 at 10:43 am
there is a scripts section here on SSC with literally thousands of script contributions.
you can use the search feature in the upper right corner of this page...
i used it to...
July 3, 2009 at 10:19 am
the default value for a column is used only if the column was not referenced in the insert.
if you include the column and it's value in the insert, the default...
July 2, 2009 at 11:42 am
doh i did not know using SSIS was a requirement....sorry...
July 2, 2009 at 9:21 am
here's how i did it:
i created a userdefined function that evaluates the three temperature types, and used a Calculated column fo rthe "flag" field.
Note I changed a few table and...
July 2, 2009 at 9:20 am
Elliott (7/2/2009)
Following the execution of the raiserror sproc you should look at @@ERRORIt would look like this:
IF ( @@ERROR = 0 )
BEGIN
EXEC SPMy_wrapper_insert
END
CEWII
that is the advantage of SET XACT_ABORT...
July 2, 2009 at 8:00 am
i think if you want code to stop on an error, you want to use SET XACT_ABORT ON and use a transaction...in that situation, when an error is raised, execution...
July 2, 2009 at 7:50 am
Just as Dave said,
that's what is a main difference between any database system and a flat file/excel spreadsheet.
SQL Server, or any other DataBase Management System, does not guarantee the order...
July 2, 2009 at 7:14 am
sarvesh singh (7/2/2009)
Try this
select * from customer where upper(surname) surname
that won't work the way you think, unless the database you are using is using case sensitive collation...you've got to...
July 2, 2009 at 6:28 am
your explanation is too abstract...you did not clearly define the matrix and the possible values(at least for me), nor the actual format of the data that will come from the...
July 1, 2009 at 11:35 am
here's the proc I use to create the trace I use; note that it creates a view at the end so I can also see the results easily.
this runs till...
July 1, 2009 at 10:19 am
i assume you have them stored in a varchar column instead of in a datetime column?
ideally, everything should be the datetime datatype...
can you rebuild the table, and set the column...
July 1, 2009 at 9:27 am
that's what is a main difference between any database system and a flat file/excel spreadsheet.
SQL server, or any other DataBase Management System, does not guarantee the order of the data...
July 1, 2009 at 9:06 am
Like Roshan said, the INSERTED virtual table makes both your triggers cleaner and easier to read;
note how your trigger would not work if multiple rows get inserted...it would only move...
July 1, 2009 at 3:46 am
Viewing 15 posts - 10,891 through 10,905 (of 13,462 total)