![](https://img-blog.csdnimg.cn/20201014180756923.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQLServer
o527883184
暂无
展开
-
SQL常用语句
CREATE DATABASE dbTest–建库 USE dbTest CREATE TABLE tbTestOne –建表 ( ID int primary key identity(1,1),–主键 自增 Name nvarchar(50) NOT NULL, Sex BIT NOT NULL, Age INT NOT NULL ) CREAT原创 2016-04-15 21:42:07 · 495 阅读 · 0 评论 -
SQL常用语句(补)
create database dbOrder use dbOrder create table OrderTb ( orderid int not null, ) create table OrderListTb ( orderListid int identity(1,1) primary key, orderid int, orderLine原创 2016-04-15 21:44:02 · 299 阅读 · 0 评论 -
SQL存储过程总结
CREATE PROCEDURE MyProc–创建存储过程 AS BEGIN SELECT 1–执行输出语句 END GOALTER PROCEDURE MyProc–修改存储过程 AS BEGIN SELECT GETDATE()–执行输出语句 END GOALTER PROCEDURE MyProc–变量声明赋值 AS BEGIN declare @a int,原创 2016-04-15 21:47:34 · 322 阅读 · 0 评论 -
SQL存储过程登陆实例
–USE [UserManage] –GO–DECLARE @return_value int, – @result nvarchar(50)–EXEC @return_value = [dbo].[UserLogin] – @name = root, – @pwd = 123, – @result = @result OUTPUT–SELEC原创 2016-04-16 21:09:12 · 683 阅读 · 0 评论 -
SQL存储过程分配宿舍实例
CREATE DATABASE DBStuManageuse DBStuManageCREATE TABLE TBROOM( ROOMID INT IDENTITY(1,1) primary key, RoomNumber INT , RoomBedCount INT, studentID INT)select * from TBROOMCREATE TABL原创 2016-04-16 21:14:42 · 1792 阅读 · 0 评论 -
C#中使用SQL语句与存储过程(非查询)
using System; using System.Configuration; using System.Data.SqlClient; using System.Data;namespace ProcedureTest { public partial class Add : System.Web.UI.Page { protected void原创 2016-04-17 22:30:10 · 692 阅读 · 0 评论 -
C# SQL带传入、输出参数及返回值的存储过程
/// <summary> /// 带传入参数的存储过程 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Button3_Click(object sender, EventArgs原创 2016-04-17 22:48:47 · 5371 阅读 · 0 评论 -
C#&&SQL 事务
存储过程写法use UserManageALTER PROC ADDUser ASBEGIN begin tran adduser--开始事务 begin try INSERT INTO USERINFO VALUES('Root','123','FALSE') INSERT INTO USERBED VALUES('1',@@ID原创 2016-04-18 19:02:06 · 378 阅读 · 0 评论 -
SQL触发器简单实例
DELETE触发器CREATE TRIGGER DELUser ON UserInfo--创建一个DELETE触发器FOR DELETE--定义出发条件ASdeclare @id intselect @id = userid from deleted--临时表deleted,在每次执行删除后生成,获取到被操纵USERIDprint '删除成功'DELETE USERBed WHERE U原创 2016-04-19 09:40:57 · 1427 阅读 · 0 评论