Viewing 15 posts - 3,856 through 3,870 (of 4,087 total)
WayneS (9/29/2010)
touchmeknot (9/29/2010)
Shawn, This might sound silly. how do you paste the code like that, as in I see a separate box there 🙂 ?
When you're working in the editor,...
September 30, 2010 at 7:14 am
pankaj.kuchaliya (9/22/2010)
when the trigger is fire then it display the "The transaction ended in the trigger. The batch has been aborted".Please help me.
Everything within a trigger--including calls to stored procs...
September 23, 2010 at 10:58 am
It's actually possible to do this without dynamic SQL and still have it be general enough that it will automatically handle changes to the table definitions.
This hasn't been completely optimized,...
September 22, 2010 at 11:54 am
I finally had a chance to test this on a table with 18K records. Here are the results for producing a grand total:
WITH ROLLUP
Table 'Worktable'. Scan count 0, logical...
September 22, 2010 at 10:27 am
sayedkhalid99 (9/22/2010)
September 22, 2010 at 6:01 am
Jeff Moden (9/20/2010)
I don't like the short version at all because it "lies".
That's very interesting, but, realistically, how often do people use nondeterministic functions like NEWID() in the comparison expression...
September 21, 2010 at 7:13 am
Luke L (9/20/2010)
I've never liked the shortened version [...] because it makes certain things unclear. (I prefer the true boolean expression syntax).
What situations do you find unclear? I...
September 20, 2010 at 2:33 pm
No. You can only update one table per UPDATE statement. You can simulate this using an INSTEAD OF trigger, but it's probably easier to just do this in...
September 20, 2010 at 6:36 am
That's a rather broad topic and probably beyond the scope of this forum unless you have a more specific question. You're better off searching for T-SQL tutorials.
I will say...
September 18, 2010 at 10:42 am
Well it's not pretty, but you can get the LOG10() of the numbers, sum them and then raise 10 to that power.
Drew
September 17, 2010 at 7:55 pm
And also the desired results. For example, if you want a single field with a delimited list of the parameters, you might want to use a subquery with a...
September 17, 2010 at 10:15 am
The system view INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS will tell you which unique constraint is referenced by each foreign key constraint. The system view INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE will tell you which columns are used in...
September 17, 2010 at 7:33 am
Jason Tontz (9/16/2010)
Thanks. That works perfectly. A little odd that the TOP statement is before the variable and not right before the column/ result list.
I don't find it at all...
September 16, 2010 at 10:45 am
Derrick Smith (9/16/2010)
r.rozeboom (9/16/2010)
But can i do this with t-sql?
i think i forgot to say it has to be done on demand. not so...
September 16, 2010 at 9:26 am
ashish.kuriyal (9/16/2010)
Why would you use DTS when you have SSIS available?
because ssis is not available in sql server 2000. Please refer original post.
He only said that the database was running...
September 16, 2010 at 9:17 am
Viewing 15 posts - 3,856 through 3,870 (of 4,087 total)