it's not really a dumb question, but one that you will end up tripping over more than once.

when you do an update like this:

UPDATE SomeColumn = (SELECT....)

the SELECT statement has...

sure...but what is the question?

you could build a string in the application and do ExecuteNonQuery("insert....")

or you could use a datatable and...

not possible from SQL. doesn't matter if you are talking exchange or an SMTP/POP3 service, there's no built in way to READ emails back.(sp_send_dbmail lets you SEND an email)

you'd have...

that kind of issue is tough...anytime you have dates in a non-datetime field, you would ideally want to change the datatype to fix that in the future. otherwise you get...

it can be confusing how you are able to get data back from a procedure.

there are three ways, and you can use them ALL at the same time:

1. reutrn a...

{Edit} just noticed you posted this in SQL2000, and CTE's are only available in 2005 and up...so the compatibility mode i mentioned isthe most likely culprit if you are...

gotcha; an exclusive table lock might occur if you are updating the whole table (SET name = UPPER(name))

or if you were updating on a range(' WHERE name like 'S%') ....the...

this is the core question for me:

Create controls dynamically per template

How is it doing that? from specific list?

tweaking the templates behavior is somethign i'd consdier.

you could have the template...

i think if you REVERSE the string, and grab up to a space, that might be pretty close to what you are after:

you can always REPLACE() to remove any...

bvsc (8/4/2011)

---

I have a table with 50 columns(col1,col2....col50)

If I want to update col5....So, Can I get col10,col15 values without x-lock???

Like update table set col5= 'updating' where col1= 10

at the same...

when i read the OP, it seemed that the data layer knew which items to capture, since his presentation will create a control for input for each item if needed,...

what's wrong with a single datatable with 200 columns, maybe with just the one row the client would be fiddling with?

then the GUI can present you 100 or 150...

this question made me explore one of those "scary places" outside my comfort zone of tsql: XQuery and XML.

I know you can get the actual XML plan from teh cache,...

Nice script Jason, I had done something similar for Hierarchy, but mentally skipped over dependencies in the other direction.

i added that to...

sqlnaive (8/3/2011)

---

I did that actually. But after doing this it shows "Query completed successfully". Thereafter when i logged in using user domain\u1, it gave me error saying "You do not...