数据库操作备忘

存储过程：

ALTER PROCEDURE dbo.InsertEmployee
 @TitleOfCourtesy varchar(25),
 @LastName varchar(20),
 @FirstName varchar(10),
 @EmployeeID int OUTPUT
AS
 insert into employees(TitleOfCourtesy,LastName,FirstName,HireDate)
 values (@TitleOfCourtesy,@LastName,@FirstName,getdate());
 
 set @EmployeeID=@@identity
 
 RETURN

 

连接数据库字串备忘：
<connectionStrings>
<add name="Northwind" connectionString="Data Source=SILVER;Initial Catalog=Northwind;integrated security=SSPI"/>
</connectionStrings>

<connectionStrings>
<add name="Northwind" connectionString="Data Source=SILVER;Initial Catalog=Northwind;User ID=sa;Password="
   providerName="System.Data.SqlClient" />
</connectionStrings>