引用处:
http://www.programfan.com/blog/article.asp?id=28128
怕这作者什么时候删除了,还是放这里存一下好点,编程要用到。
create database DBPromary
...
引用处:
http://www.programfan.com/blog/article.asp?id=28128
怕这作者什么时候删除了,还是放这里存一下好点,编程要用到。
create database DBPromary
...
#region 数据库备份 BackupData
/// <summary>
/// 数据库备份
/// </summary>
...
///sql查询分析器里面操作
///删除视图
if exists(select table_name from information_schema.views where table_name='v_user')
drop view v_user
///创建视图
create view v_user
...
(含中文插入处理)
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spGenInsertSQLHan]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[spGenInsertSQLHan]
GO
SET QUOTED_IDENTIFIER ON
GO
...
----查询数据库中用户创建的表----jsj01 为数据库名select name tablename from jsj01..sysobjects where type='U' and name not in ('dtproperties')--查询表里的字段信息 ---docs为表名---- select * from syscolumns where id = object_id('doc
CREATE PROCEDURE [SpPageOrder]
@tblName varchar(255),
@fldName varchar(255),
@OrderfldName varchar(255), -- 排序字段名
@PageSize int = 10,
...