<< Get the URI of the root SharePoint site in a web application and instantiate a SPWeb object for it | Can not log into web site from local machine when using Integrated Authentication / Security >>

Insert into table using a stored procedure.

This examble is using a table variable.

DECLARE  @People TABLE (
    ContactID INT,
    FirstName NVARCHAR(50),
    LastName NVARCHAR(50)
)

INSERT @People (ContactID, FirstName, LastName)
EXEC dbo.GetPeopleByLastName @LastName = 'Alexander'

8793734a-176f-4c22-9d94-b9723619f1ed|0|.0

Tags: table variable, stored procedure, insert

Categories: Databases | SQL

Posted by wizgod on Thursday, February 25, 2010 6:33 PM

E-mail | Kick it! | DZone it! | del.icio.us

Permalink | Comments (2) | Post RSS RSS comment feed

Create a table in Oracle stored procedure or functionUse the following: EXECUTE IMMEDIATE 'CREATE TABLE MyTable (id NUMBER)'; Creating stored procedures in Oracle/PLSQLThe syntax for a procedure is: CREATE [OR REPLACE] PROCEDURE procedure_name [ (parameter [,par...JTableMenu::store failed - Duplicate entry '0' for key 1 SQL=INSERT INTO `jos_menu` (If you get this it means the auto-increment isn't set for the id primary key in the table. All you ...

Comments