If you want SSMS to generate the extra stuff, go to the Tools menu, select Options, go to SQL Server Object Explorer and then Scripting underneath that. You can...

I'm not going to provide a primer on how to accomplish sql injection, but I can tell you the code you've provided is not sufficient to prevent it. I...

Since you gave such little information it's hard to help you out very much. Not sure if I even understand exactly what you're asking.

That being said, I would do...

Interesting post (and a bit quirky to see the anti-stored proc crowd banding together) ... I feel compelled to respond:

If you're having issues...

I think the XML function just particularly dislikes the "<" and ">" since those characters have such significance in the XML structure. If you just replace those after the...

Not a big deal, but in the future you're probably more likely to get relevant responses in the T-SQL forum for SQL Server 7 and 2000.

bolson32 (8/10/2010)

---

Well we're getting there, unfortunately isnull only replaces it if it returns NULL, which this just doesn't return a row. I do however think I can use a view...

I would create one stored procedure with...

bitbucket-25253 (8/9/2010)

---

Celko is at it again

http://www.sqlservercentral.com/Forums/Topic965546-1292-1.aspx#bm966047

For a community which attempts to help, even the most inept, and helps so many this guy Celko is a real detriment ....

Is there...

rjv_rnjn (8/9/2010)

---

It appears you want to do the insert & update through a single query. You can't do that in SQL 2005. You will have to identify a logic to...

If you have 60 columns in a table there are likely to be other issues with your design. All the same, if there is some reason why the table...

You've been around here enough that you should start posting what sort of solutions you're coming up with on your own, even if they're incomplete. You'll learn a lot...

I applaud your efforts as a C# developer to do this in T-SQL, which is the right way to go. There are some issues with your basic approach and...

It is possible but since you haven't explained your structure I can't give you example code. See the link in my signature for information on how to post your...

You don't need a cursor or while loop, but you do need to provide quite a bit more information to get a coded example. Please see the link in...