真爱无限的知识驿站

-- 获取锁

ALTER procedure [dbo].[pro_get_sys_ordr_lock_info](   

     @ORDR_HEAD_SEQ 编号,  

     @ORDR_TYP_CD VARCHAR(20)  

 )as  

begin   

set ANSI_NULLS ON  

set QUOTED_IDENTIFIER ON  

go  

/*****************************************************  

** PROCEDURE : pro_set_so_cust_info  

** DECRIPTION: 维护客户资料信息  

set ANSI_NULLS ON  

set QUOTED_IDENTIFIER ON  

go  

  

/*****************************************************  

** PROCEDURE : pro_get_so_cust_list  

** DECRIPTION: 获取客户列表  

set ANSI_NULLS ON  

set QUOTED_IDENTIFIER ON  

go  

/*****************************************************  

** PROCEDURE : pro_is_so_cust_nam_show_repeat  

** DECRIPTION: 判断客户用户和或显示名称是否重复  

select * from salaryinfo where datepart(yyyy,salarydate) =datepart(yyyy,GetDate()) and datepart(mm,salarydate)=datepart(mm,GetDate()) and datepart(dd,salarydate)=datepart(dd,GetDate())

引用处：

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