Viewing 15 posts - 10,366 through 10,380 (of 13,469 total)
einman33 (11/3/2009)
November 3, 2009 at 8:19 am
Jeff Moden (11/3/2009)
This is about the 3rd time this question has been asked in as many days... why do you need to know this?
homework questions, you think? trying to make...
November 3, 2009 at 6:18 am
lol no, MS does not issue any default system triggers, that's for sure...also you can kind of tell by the name:'DDLTriggerTest'
definitely some trying out some code.
November 2, 2009 at 9:28 am
Feebie (11/2/2009)
when u tried to modify the procedure then it gives me error like this...
Procedure tr_ProcedureEvents, Line 6
Invalid object name 'DDLTriggerTest..EventTableData'.
please let me know what causes this...
November 2, 2009 at 8:37 am
the answer is yes and no.
once I have a username and password, I'm good to connect with anything i can get my grubby fingers on...SSMS, a program i write, Access,Excel,...
November 2, 2009 at 8:28 am
without more details, all i can offer is an example:
in this case, I've wrapped the counting sql with another query to get me the isnull of the count.
SELECT ISNULL(CNT,0) As...
November 2, 2009 at 8:00 am
ahh, that's the difference between a variable and an array of values:
SQL will not auto convert a string(@var) into an array of values...you have to explicitly do it.
select name...
November 1, 2009 at 5:07 am
simple i think:
ad a preceeding and ending single quote, and replace every comma with singlequote-comma-singlequote
that will work weather there is one value or lots of values.
SELECT '''' + REPLACE(YourColumn,',',''',''') +...
October 31, 2009 at 7:22 pm
i've done this all via TSQL; I happen to also get all the scripts in FK hierarchy order as well.
this has a dependancy for the procedure sp_GetDDL, which gets any...
October 30, 2009 at 9:49 am
i use this and stick it in master:
usage is simply sp_kill databasename
this is simliar to Sanjay's, but a little more robust on a couple of validation things like your own...
October 30, 2009 at 9:13 am
Shabba (10/30/2009)
the unregisted version of Editplus is free, with only a single nag screen at startup. it is completely full featured, with just a reminder screen .
hmmm... can only seem...
October 30, 2009 at 8:16 am
Shabba (10/30/2009)
Thanks for all the responses. Lowell that's exactly what i'm after do you know of a free alternative to EditPlus?Cheers,
Mark
the unregisted version of Editplus is free, with only...
October 30, 2009 at 7:51 am
i use the cliptext feature of Editplus to save all my snippets and valuable code; i try to organize with a keyword and brief description;
if i double click on the...
October 30, 2009 at 7:15 am
ok, if things run under a default account like you said, this is my next guess: does it return the correct results?
Select
'Sept'as mnth,
td.tdes_m,
tran_x,
...
October 30, 2009 at 5:31 am
this is just a guess, but i think this would return a result set for all of your numbers, so you can avoid a cursor.
Select
'Sept'as mnth,
...
October 29, 2009 at 5:48 pm
Viewing 15 posts - 10,366 through 10,380 (of 13,469 total)