executing SQL statements in SQL Server

[Guest_imported]

Hi, everyone!
Has anyone seen the SQL statement structured like this one:
execute(exec sp_somename....)?
If yes, could you, please, give me some advice on what it is and how to use it.
Preferably, with a simple example.
Thank you.

 

[DougP]

Well "Stored Procedures" are like macro's in other languages or Program. Its a series of commands that SQL server recognizes and do certain things to the database. Just about anything imaginable can be done in stored procedure. Create new tables, add records etc.

So execute(exec sp_somename....)?
means Execute (or run) a stored procedure called SP_somename
SP_ is usually always the first letters so you can identify it as such.

I don't think you need both Execute and Exec together they both mean the same thing.
DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive