SQL信息
colin
这个作者很懒,什么都没留下…
展开
-
关系两个表进行二维信息SQL中cross join
主要用cross join 就可以查询出这积insert into tbmcd_config_city_perform(editor,edittime,city_id,post_id,perform_id,change_value)select {0},{1}, 0, post_id ,perform_id,0.00 from (select id as post_id from原创 2009-02-03 16:26:00 · 344 阅读 · 0 评论 -
SQL 表的Insert ,update ,delete 触发器
<br /> 建一个跟源表一样的表,记录源表所有操作信息。<br /><br />ALTER trigger [dbo].[test_Trg] on [dbo].[test]<br /> for insert,update,delete <br />AS<br /> <br />If not exists(Select 1 from deleted)<br /> INSERT INTO test_Trg SELECT *, 'INSERT', getdate(), substrin原创 2010-08-05 15:28:00 · 578 阅读 · 0 评论 -
SQL Server 2008 获取表结构信息
<br />SQL Server 2005 & 2008 获取表结构信息 <br /> <br /> SELECT <br /> 表名=case when a.colorder=1 then d.name else '' end,<br /> 表说明=case when a.colorder=1 then isnull(f.value,'') else '' end,<br /> 字段序号=a.colorder,<br /> 字段名=a.name,<br /> 是否种子标识=c原创 2010-10-22 12:26:00 · 1172 阅读 · 0 评论