Miss.LV的专栏

set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go -- 获取指定页的数据，可以为返回字段重新命名别名 ALTER PROCEDURE [dbo].[ExpGetRecordFromPageByotherFieldsName] @TableName VARCHAR(4000), --表名 @FieldList VARCHAR(4

--创建数据库 if exists (select * From master.dbo.sysdatabases where name='DirectionDemo') drop database DirectionDemo create database DirectionDemo on ( name = 'DirectionDemo', filename = 'd:\Direction

ALTER proc [dbo].[InsertUser] (@userID int output , @userName varchar(50), @password varchar(50), @userAge int , @userAddress varchar(50), @telephone int ) as insert into users values ( @userName ,