天马行空

（1）  right('0000'+convert(varchar(4),column_name),4)

SP 傳了兩個參數進來，可以使用如下SQL處理非空CREATE/ALTER Procedure [dbo].[sp_name](@param1 varchar(20),@param2 varchar(20))ASSELECT    column_1, column_2FROM    table_1WHERE ( column_1 >= @param1 or  isnull(@param1,'')=

後台更新數據時，記得把Trigger停掉再update  alter table table_name disable trigger allupdate table_name set status = 1 where Criteria='' alter table table_name enable trigger all

查詢當前數據庫的表對象是否存在IF EXISTS(Select * From sysobjects where xtype='U' AND Object_ID(N'table_name')=id) Print 'Exists'ElsePrint 'Not Exists'

語法如下，替換粗體字即可。select column_name from database_name..table_namewhere column_name  in (select column_name  from database_name..table_name WHERE cretaria like '%%'  group by column_name  ha

用sql server 2010运行，报如下错误：Shutdown is in progress 待重启数据库服务器之后，恢复正常。

Msg 7202, Level 11, State 2, Line 3Could not find server 'AAA' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add

The EXECUTE permission was denied on the object 'uf_date', database 'AA', schema 'dbo'.今天需要导出295个Contract，一共是6W多条数据，执行报如上错误。sql 语句大概是这样子的格式：select  column_1, column_2, uf_date(column_3),

做SQL统计报表的时候，调试报错如下：Msg 205, Level 16, State 1, Line 1All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.说

调试SQL时出现如下提示：Msg 8156, Level 16, State 1, Line 2The column 'customer' was specified multiple times for 'MM'.说明：customer 是父，子表均有的字段MM为父表的简称定义解决方案： 重新定义父表的customer字段即可。