sql
whilewk
The best way to write secure and reliable applications. Write nothing; deploy nowhere.
展开
-
sql、select查询除了某一列的数据
declare @table varchar(100)declare @a varchar(2000)set @table='AF_AllCaseInfo'--表名select @a=ISNULL(@a,'')+','+name from sys.columns where object_id=(select object_id from sys.tables where name转载 2017-09-18 17:33:06 · 11593 阅读 · 1 评论 -
sql 查询除某列之外的数据
declare @table varchar(100)declare @a varchar(2000)set @table='AF_AllCaseInfo'--表名select @a=ISNULL(@a,'')+','+name from sys.columns where object_id=(select object_id from sys.tables where name=@ta...转载 2018-03-22 11:11:06 · 10202 阅读 · 0 评论 -
sqlserver死锁
sqlserver死锁症状:事务与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务解决:select db_id('wisdom315')select * from sys.sysprocesses where dbid=22kill 572,oracle 死锁症状:定时作业不执行,不能删除 执行报系统错误解决:select session_id from v$locked...原创 2018-06-20 16:03:37 · 285 阅读 · 0 评论