搜索资源列表
MSSQLPage
- MSSQL数据库分页 CREATE proc GetData @SQLSTR varchar(2000), @PageNo int, @PageSize int, @OnceMoreSize int, @PageCount int output, @RecordCount int output as-MSSQL database paging CREATE
DB1
- /*** Object: Table [dbo].[mabs] scr ipt Date: 03/21/2011 20:18:56 *** / IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N [dbo].[mabs] ) AND type in (N U )) DROP TABLE [dbo].[mabs] GO /****** Object: Table [dbo].[mabs] scr ip
CREATE-TABLE
- 表中某列被修改后触发器SQL例子，不能获得修改前的值。-CREATE TABLE [TEST] ( [FID] [int] IDENTITY (1, 1) NOT NULL , [F1] [int] NULL , [F2] [int] NULL , [F3] [int] NULL , CONSTRAINT [PK_TEST] PRIMARY KEY CLUSTERED
procedure
- 图书管理系统的存储过程 方便系统开发 s使用SQL时常用的代码-easy practical。you can use it as a materila to learn sql.yes as declare @ERROR int begin update tbBookInformation set
lab1
- I. Query with SQL Server 2005. (30’, 2’ for each) 1. Create a table named Student using command Create Table. The table structure is as follows: Column Type Length Note ID Varchar 20 Student’s ID Name Varchar 10 Student’s Name Age Int Stud
自动升级文件和上传升级文件程序
- 上传局域网内自动升级文件(update.pbw)和上传最新升级文件(ftp_update.pbw) 把编辑好的update.exe放在当前应用的下面，即可自动升级。 需建表 系统版本控制表 system_set 字段 cur_ver vchar 程序升级表 CREATE TABLE t_updata( [ver] [char] (5) NOT NULL , [filename] [varchar] (30) NOT NULL , [fileblob]