随笔分类 - Sql Server

SQL删除重复记录

摘要：CREATE TABLE [dbo].[Test]([id] [int] IDENTITY(1,1) primary key NOT NULL,[name] [varchar](20) NULL,[age] [varchar](4) NULL)goinsert into Test(name,age)values('connor','22'),('connor','23'),('connor','23'),('summerleoo','22'),('summer 阅读全文

posted @ 2012-03-14 12:02 justconnor 阅读(246) 评论(0) 推荐(0)

如何在定义游标的时候使用动态sql语句

摘要：declare @GetCaridStr Nvarchar(1000) ;set @GetCaridStr = 'DECLARE LandAreaO_Cursor CURSOR FOR select carid from car_info where companyid not in(select companyid from company_info where list2 =543 and list3 =543 and status =1) and car_type in ('+ @Key_CarType +')';Exec(@GetCaridStr) ; 阅读全文

posted @ 2011-11-07 14:16 justconnor 阅读(1888) 评论(1) 推荐(1)