easy fix: once you aliased #example, you have to use that alias everywhere:

update ex -- the table that will be updated's alias.

set Status = 1

from...

yeah, it doesn't add buttons to the titlebar of a form; it just sintercepts specific keystroke command sand calls the windows API's to fiddle with the widnow size.

i found that...

you got me curious with this, and i found SecondShell

http://www.secondshell.com/

clicking ALT and mousedrag makes any window stretch in the direction of the alt+drag, and there are programmable hotkey sequences...

david.alcock (1/11/2011)

---

But you could place certain procs, not all, into a schema and assign the permissions to a role at schema level cant you?

Yes it may be painful...

i think if you create a role, you can GRANT EXECUTE TO YOURROLE, but that grants execute on all functions as well.

CREATE ROLE [ReallyReadOnly]

GRANT EXECUTE TO...

nope, it's free distributable:

The Report Viewer Control is a free control provided by Microsoft to display reports on a web page or windows form. To add the Report Viewer...

well, my two cents:

I have no problem using it for production or anywhere else. It exists in 2005,2008/R2 and Denali/V11 as well... so anything I incorporate using that would...

your data in a format anyone can use in SSMS to look at the problem properly:

SELECT '1' AS VehicleID,'Honda' AS CarName,'Smith' AS VendorName,'20' AS Quantity,'25000' AS Price UNION ALL

SELECT '1','Honda','Ross','30','20000'...

I'd like to take a stab at this one; i've got a lot of examples I post to the forums on the subject.

it depends on your data.

if you are absolutely sure there are only two spaces in the field for every single record, you could use something like CHARINDEX2 and substrings to...

Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "MSDASQL" for linked server "AS400" reported an error. The provider reported an unexpected fatal error.

Message 7330, Level 16, State...

your probably doing it right.

The important thing to remember about sp_executesql is that it is susceptible to SQL Injection. since using parameters defeats that security hole, simply using params everyplace...

I agree with Koen, a MERGE statement would work perfectly...only problem I forsee is the...

kind of... you can use this example to put together jsut a final script that executes a varbinary(max) ...so the proc body is not so obvious.

just remember that SQL Server...

a datatable in .NET has a flag on each row that signifies whether the row has been changed;

typically at our shop, we test a datatable,(usually from a types dataset, but...