Stored Procedures fuer den Ms SQL-Server
C# and VB code examples about:
how to create procedures, tables, grant privileges etc. by using C# and ADO.NET
The examples are mostly pretty simple, but very frequently needed. It sucks to look for them.
So, here we go. First just a methode to create a table and after, - privileges will be set to it.
C#
Create Table
Create Table with Parameters
Grant Table Privileges
Grant Table Privileges with Parameters
Create Procedure
Create Procedure with Parameters
Grant Procedure
Grant Procedure with Parameters
Insert Into: using StoredProcedure
How to store time and date separately into sql server
How to Add a new Column
How to get the Instance of the MsSQLServer
How to put SET IDENTITY_INSERT
to a MsSQLServer SQL-Statement
How to check if a Table exists
Error at:
EXEC('CREATE PROCEDURE
scalar variable must be declared
Create Table
Create Table with Parameters
Grant Table Privileges
Grant Table Privileges with Parameters
Create Procedure
Create Procedure with Parameters
Grant Procedure
Grant Procedure with Parameters
Insert Into: using StoredProcedure
How to store time and date separately into sql server
How to Add a new Column
How to get the Instance of the MsSQLServer
How to put SET IDENTITY_INSERT
to a MsSQLServer SQL-Statement
How to check if a Table exists
Error at:
EXEC('CREATE PROCEDURE
scalar variable must be declared
VB
Create Table Create Table with Parameters
Grant Table Privileges
Grant Table Privileges with Parameters
Create Procedure
Create Procedure with Parameters
Grant Procedure
Grant Procedure with Parameters
Insert Into: using StoredProcedure
How to store time and date separately into sql server
How to Add a new Column
How to get the Instance of the MsSQLServer
How to put SET IDENTITY_INSERT to a MsSQLServer SQL-Statement
How to check if a Table exists
Error at:
EXEC('CREATE PROCEDURE
scalar variable must be declared
Create Table Create Table with Parameters
Grant Table Privileges
Grant Table Privileges with Parameters
Create Procedure
Create Procedure with Parameters
Grant Procedure
Grant Procedure with Parameters
Insert Into: using StoredProcedure
How to store time and date separately into sql server
How to Add a new Column
How to get the Instance of the MsSQLServer
How to put SET IDENTITY_INSERT to a MsSQLServer SQL-Statement
How to check if a Table exists
Error at:
EXEC('CREATE PROCEDURE
scalar variable must be declared
{
string strSQL = "CREATE TABLE [dbo].[" + strtblName + "]" + "([IDNr][int] NOT NULL PRIMARY KEY CLUSTERED," + " [FldBit][bit], [FldSmallint][smallint],[OrderDate][datetime]," + " [FldChar][char](10),[FldNumeric][numeric](18, 0)NULL) ON [PRIMARY]";
try
{
myCnn.Open();
myCmd.Connection = myCnn;
myCmd.CommandText = strSQL;
myCmd.ExecuteNonQuery();
}
catch (Exception ex )
{
myCnn.Close();
//MessageBox.Show("error in Methode: CreateTable = " + ex.Message);
throw new Exception(ex.Message);
}
finally
{ myCnn.Close(); }
//This is a download for a the whole class, within a winform project. download
}
MHSoft Ltd. | UTR 623 17168 26211 A | Fax: (49) 0321 212 010 47