Frankwangyifang

摘要： SQL 关键字:1,CAST:SELECT CAST(productID as varchar(30)+':'+productName) as Name from Prouduct --把 int 转为 varchar 类型去处理. (相当于string.Formate()方法. )2, CASE:SELECT studentName,case Score　　when Score<60 th... 阅读全文

摘要： IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UserInfo]') AND type in (N'U'))BEGINCREATE TABLE [dbo].[UserInfo]([UserID] [bigint] IDENTITY(999999999999999999,10000000) ... 阅读全文