摘要:
a.js if (typeof SNAP_COM == "undefined") { SNAP_COM = { }; } SNAP_COM.shot_config = { version:"2.20.1",prefix:{ image:"http://shots.snap.com/images/v2.20.1/",cdn:"http://i.ixnp.com/",cdn_image:"htt... 阅读全文
摘要:
写一个触发器。从tb_control里删除一条记录,自动把该记录添加到另一个表tb_ctrlHistor中 create TRIGGER save_history ON tb_control FOR delete AS IF @@ROWCOUNT>0 BEGIN INSERT tb_ctrlHistor SELECT column_name_1,column_name_12 FROM ... 阅读全文
摘要:
新闻[2007]0714号 连续剧[2007]0714号 取出[符号前的字符 怎么取 ? select SUBSTRING(ColunmnName,1,charindex('[',ColunmnName)) from yourTable 阅读全文