luhuabin的专栏

--在数据库test中创建表aause testgocreate table aa(id int primary key not null,name1 varchar(20),name2 varchar(20),name3 varchar(20))--在数据库test1中创建表bbuse test1gocreate table bb(id int primary key not null,name

数据库结构的脚本:if exists (select * from dbo.sysobjects where id = object_id(N[dbo].[TempA]) and OBJECTPROPERTY(id, NIsUserTable) = 1)drop table [dbo].[TempA]GOCREATE TABLE [dbo].[TempA] ( [id] [int] I

 DECLARE @mny moneySET @mny = 123456.16SELECT SUBSTRING(convert(varchar,cast(@mny as money),1),0,CHARINDEX(.,convert(varchar,cast(@mny as money),1)) ) as MONEY

 BCP "select * from dbCheck.dbo.tablename with(nolock)" queryout D:/tbl -S172.17.1.1 -Usa -Psa -N BCP dbname.dbo.tablename in "D:/tbl" -S172.17.1.1 -Usa -Psa -N

 code:str.Replace("[", "[[").Replace("_", "[_").Replace("%", "[%").Replace("-", "[-").Replace("]", "[]").Replace("^", "[^"); sql:where field LIKE % + @vcparameter + % ESCAPE [

 select replace(field,char(13)+char(10), )