karthik babu (12/3/2013)

---

thanks for your interest...

Please check the below code..

set rowcount 40000

Update T1 SET sName = t2.sName

from dbo.t_table1 T1 INNER JOIN dbo.t_table2 T2 ON t1.tID =...

lianvh 89542 (12/2/2013)

---

Good Day,

we use varchar(max) , and I also read Text is to be depricated . My concern is this : You'll have poor performing queries on this column...

is the...

what version is your SSMS tool actually running?

I've seen similar issues with the scripting of objects, where a prior version of SSMS cannot work correctly against a higher version...

sheesh, i know that, explained that lots of OTHER times,...

two primary keys, by definition, would be repetitively redundant 😀 if you think about it.

essentially the primary key's main purpose is to be able to uniquely point to each...

rray 44280 (11/27/2013)

---

I have a query that returns a bunch of rows. I have an sp that takes 3 of the columns in the query as parameters that I want...

JimS-Indy (11/27/2013)

---

It's a left join, so there will be I rows without L rows. In that case, I'm done, and need only one message ('Adding New PO Line to CPAS')....

for a single stored procedure, you would grant view definition on the User in the database(or the role/windows group)

GRANT VIEW DEFINITION ON dbo.DelimitedSplit8K to ClarkKent;

GRANT VIEW DEFINITION ON dbo.DelimitedSplit8K...

Jim i see the join critieria is this:

LEFT JOIN tblPOLine AS L

ON I.POID = L.POID

AND I.POLINENUM =...

you have to make sure ALL of your variables are the same (nvarchar(max))

Truncation when concatenating depends on datatype.

if you do something like this:

nvarchar(max) + varchar(n)

SQL will first convert the...

mailtoashokberwal (11/27/2013)

---

Any suggestion on below:

I need to compare two strings which have comma separated ISO Country codes.

For example : String1 = '356,840'

...

if not too much time has passed, it will be in the default trace;

but the default trace only keeps a rolling history of 100 meg, so it could get pushed...

ok, flexing my Google-Fu a little bit, i found this article that might help; it claims to find long running jobs in 2000-2008 versions:

http://archive.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=AgentLongRunning

I don't have a 2000 server to test agaisnt, but assuming...