達可達與我
我與達可達
posts - 36, comments - 25, trackbacks - 0
我的連結
藍色小舖
小舖部落格
Home
Contact
Syndication
Login
News
每月文章
December, 2007 (1)
November, 2007 (3)
October, 2007 (11)
September, 2007 (1)
April, 2007 (4)
March, 2007 (6)
February, 2007 (5)
January, 2007 (2)
December, 2006 (3)
隨筆分類
C#
(rss)
JavaScript
(rss)
SQL
(rss)
生活隨筆
(rss)
影像集
小舖Blog圖片
My New Blog
vlog 168
編程一路發
(rss)
SQL 批次修改定序(組字串)
SELECT 'ALTER TABLE '+A.name+' ALTER COLUMN '+B.name+ CASE WHEN B.xusertype = 231 THEN ' nvarchar' WHEN B.xusertype = 175 THEN ' char' END+' ('+ convert(varchar,B.prec)+') COLLATE Chinese_Taiwan_Stroke_BIN '+ CASE WHEN B.isnullable=1 THEN 'NULL' ELSE 'NOT NULL' END FROM dbo.sysobjects A INNER JOIN dbo.syscolumns B ON B.id=A.id WHERE A.type='U' AND B.collation='Chinese_Taiwan_Stroke_CS_AS' ORDER BY A.name
posted on Wednesday, October 03, 2007 11:46 PM
Feedback
No comments posted yet.
Post Comment
Title
Name
Url
驗證碼
Comment
Remember Me?