Viewing 15 posts - 226 through 240 (of 362 total)
[font="Verdana"]Carlo, can you tell us, what exactly error you are facing?
Mahesh[/font]
April 30, 2008 at 4:46 am
[font="Verdana"]Duplicate Post
http://www.sqlservercentral.com/Forums/Topic492577-338-1.aspx[/font]
April 30, 2008 at 4:27 am
[font="Verdana"]Well in that case you need to go the way Chirag has shown.
Mahesh[/font]
April 30, 2008 at 3:05 am
[font="Verdana"]Then why don't you go for Replication?[/font]
April 30, 2008 at 2:51 am
[font="Verdana"]
Ashwin M N (4/30/2008)
I have disabled a trigger on a particular table.Will the trigger be enabled if the the sql server service is restarted.
You need to enable the Trigger manually...
April 30, 2008 at 2:40 am
[font="Verdana"]As per my knowladge there is no such way to do this[/font]
April 30, 2008 at 2:38 am
[font="Verdana"]Satish, I think you have already got the answer for this question. One of the expert have already told you that it can't be done. Even the error message is...
April 30, 2008 at 1:21 am
[font="Verdana"]
SQL ORACLE (4/29/2008)
Here are two links, I believe they can help.http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1063700,00.html
Hi, in the first URL you have given, Author has mentioned
You'll also find that although a SPROC can...
April 30, 2008 at 1:17 am
[font="Verdana"]
... and, just to be sure, you can do INSERTs, UPDATEs, and DELETEs on Table Variables in a UDF... just not on external tables.
Jeff, I was talking about regular tables...
April 30, 2008 at 1:11 am
[font="Verdana"]
mick burden (4/29/2008)
Mahesh, I'm sure you are correct, but I would also like to able to store the html as well
Just curiosity, what kind of application you are developing?
Mahesh[/font]
April 30, 2008 at 12:50 am
[font="Verdana"]
Chirag (4/29/2008)
HiWhat about using a Left join instead of "OR". This will have a better execution plan.
Do you mean, joining TableA to TableA with left outer join will give better...
April 30, 2008 at 12:45 am
[font="Verdana"]Can you explain what exactly you are trying to do? these is no need to link different DBs under same server. You can access objects from 2nd DB while you...
April 30, 2008 at 12:39 am
[font="Verdana"]
...I also need to show Skill_Groups that do not have any Jobs_Created_Last_7_Days...
Select category, count(dbjobskillgrp), count(dbjobstatus)
From {Table}
Where ...
April 29, 2008 at 10:57 pm
[font="Verdana"]
goto err
Ram, have you written err: at the end of SProc(i doubt), so that whenever you write GOTO it will switch to the error handling label? The...
April 29, 2008 at 10:00 pm
[font="Verdana"]
1. In SProc you can write Select, Insert, Update, Delete statements where in Functions only Select statements can be return.
2. SProc can not be called in Select statement where as...
April 29, 2008 at 6:25 am
Viewing 15 posts - 226 through 240 (of 362 total)