- 博客(2)
- 资源 (1)
- 收藏
- 关注
RSS订阅翻译 使用AT再远程服务器执行查询
EXEC和EXECUTE主要是用来执行存储过程、SQL语句等。 但它不仅限于执行本地SQL的对象,和AT参数结合，可以执行远程服务器的存储过程，SQL语句等下面是简单的例子：创建Linked Server：EXEC SP_AddLinkedServer '192.168.1.10', 'SQL Server'EXEC sp_addlinkedsrvlogin '192.168.1.10', 'f
2016-04-26 10:31:30
856
原创 使用CHOOSE使用举例-动态排序字段
CHOOSE在SQL Server2012后才开始支持。在2012前需要用CASE实现用法：https://msdn.microsoft.com/en-us/library/hh213019.aspxprint CHOOSE (abs(checksum(newid()))%5+1 , 'A','B','C','D','E')go 10Beginning execution l
2016-04-07 10:07:28
532
XPCC-XP Common Control
This projects includes some of the most missed XP Controls in .net 1.1, like a taskbox, a grouped listview, a letterbox control and others.
It also includes ownerdrawn theming, so it will run on any machine with the .net-framework installed (Win95/98/2000). Some of the features will work only on Windows XP though.
2009-07-10
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人