scarroot

立志于开发稳定,高性能,容易维护的系统. 追求系统模块化设计,精简与强大的内核框架，可插拔的功能模块

 

随笔分类 -  SQL

sql
列出表结构.
摘要：Code Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->SELECT SysObjects.Name as tb_name, SysColumns.Name as col_name, SysTypes.Name as col_type, SysCo... 阅读全文

posted @ 2009-01-16 15:18 scarroot 阅读(205) 评论(0) 推荐(0)

在所有表中查找某个值
摘要：Code Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->--在整个库里查某个值 declare @str varchar(100) set @str='6923346741083' --要搜索的字符串 declare @s varcha... 阅读全文

posted @ 2008-12-08 15:35 scarroot 阅读(279) 评论(0) 推荐(0)

导航