Viewing 15 posts - 2,131 through 2,145 (of 2,894 total)
Could you please follow the link at the bottom of my signature to find out how to present this sort of question to the forum. I can promise you: you...
February 21, 2012 at 5:13 am
Koen Verbeeck (2/21/2012)
February 21, 2012 at 5:10 am
You need to compare new value with previous one, which can be found in DELETED:
UPDATE t1
SET pricechange = case when D.price < i.price then 1 else...
February 21, 2012 at 4:36 am
Jeff Moden (2/19/2012)
Eugene Elutin (2/19/2012)
rajeev_vandakar-782919 (2/18/2012)
It's not totally possible, and anyway you would still better to write normal sql and update all 30-40 columns.
Not if you have triggers based on...
February 21, 2012 at 4:12 am
deepkt (2/21/2012)
Thanks for the reply Eugene Elutin.Is there any other way without configuring Ad Hoc Distributed Queries option?
Thanks
No! There is none!
But I still don't understand what you are trying to...
February 21, 2012 at 4:01 am
can you please post a stored proc definition which causes problem. I've run the query for procs which contain /* comments and it looking just fine.
February 21, 2012 at 3:57 am
another way:
select parsename(replace('0005 ganeshkumar A999',' ','.'),1)
February 21, 2012 at 3:26 am
Have you switched the output into Text?
February 21, 2012 at 3:13 am
What is the reason you want to do it?
Very strange question... Why would you need to determine the datatypes for recordset returned by stored proc? You should know them from...
February 21, 2012 at 3:08 am
You need to separate create proc statements with batch-end "GO"
Switch query output to text and execute:
select Definition
from
(
SELECT SM.Object_ID o, 1 ord, SM.Definition
FROM SYS.SQL_Modules As SM INNER JOIN SYS.Objects As...
February 21, 2012 at 2:46 am
To get full protection from SQL injection, you should use sp_executesql with parameters. Also, it will sort out your problems with quotes...
February 20, 2012 at 10:07 am
rajeev_vandakar-782919 (2/18/2012)
...Any method is there where in the query or stored procedure, we can find out which column(s) now affecting and use only those columns in the UPDATE query?
Whatever you...
February 19, 2012 at 3:52 pm
Thank You, Gail!
Finally OP can make fully qualified decision of what size he need for his nvarchar! :hehe:
February 17, 2012 at 9:46 am
You will find answer here:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
February 17, 2012 at 9:37 am
Viewing 15 posts - 2,131 through 2,145 (of 2,894 total)