摘要:
select a.name 表名,b.name 列名 from sysobjects a,syscolumns b where a.id=b.id and b.name='表名' and a.type='U' 还算经常使用 转载自 http://www.cnblogs.com/dahuzizyd/archive/2007/02/02/sql.... 阅读全文
摘要:
Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->unction GetUrlParms() { var args=new Object(); var query=location.search.substring(1);//获... 阅读全文
摘要:
使用newid()随机选择多行,可以使用newid()函数,newid()函数用来产生guid,你也可以 insert into test1 values(newid()) SELECT *FROM Northwind..Orders ORDER BY NEWID() SELECT TOP 10 * FROM Northwind..Orders ORDER BY NEWID() 阅读全文