随笔分类 -  SQL Server

SQL_server 将表中的记录 转换成 Insert(插入) SQL 语句
摘要:create proc spGenInsertSQL @TableName as varchar(100) as --declare @TableName varchar(100) --set @TableName = 'orders' --set @TableName = 'eeducation' DECLARE xCursor CURSOR FOR SELECT name,xusertype FROM syscolumns WHERE (id = OBJECT_ID(@TableName)) declare @F1 varchar(100) de... 阅读全文

posted @ 2013-06-06 15:30 哈哈哈哈BBA 阅读(2095) 评论(0) 推荐(0)

SQL Server 如果视图存在执行删除
摘要:IF EXISTS(Select Name From Sysobjects Where Name='P_ExistsDropView' And Xtype='P')DROP PROC P_ExistsDropViewGOCreate Proc P_ExistsDropView(@DelView Varchar(200))AsDeclare @SQLText Varchar(1000)If Exists(Select Top 1 Name From Sysobjects Where Name=@DelView And XType='V') Begi 阅读全文

posted @ 2013-04-17 14:48 哈哈哈哈BBA 阅读(4035) 评论(0) 推荐(0)

SQL Server 如果表存在执行删除
摘要:IF EXISTS(Select Name From Sysobjects Where Name='P_ExistsDropTable' And Xtype='P')DROP PROC P_ExistsDropTableGOCreate Proc P_ExistsDropTable(@DelTable Varchar(200))AsDeclare @SQLText Varchar(1000)If Exists(Select Top 1 Name From Sysobjects Where Name=@DelTable And XType='U') 阅读全文

posted @ 2013-04-17 14:45 哈哈哈哈BBA 阅读(10858) 评论(0) 推荐(0)

SQL Server查看所有表大小,所占空间
摘要:--主要原理: exec sp_spaceused '表名' --取得表占用空間 exec sp_spaceused ''--數據庫所有空間 create table #Data(name varchar(100),row varchar(100),reserved varchar(100),data varchar(100),index_size varchar(100),unused varchar(100)) declare @name varchar(100) declare cur cursor for select name from sysobje 阅读全文

posted @ 2013-04-16 16:41 哈哈哈哈BBA 阅读(372) 评论(1) 推荐(1)

SQL Server游标循环读取
摘要:declare @DJBH varchar(50)declare @DM2 varchar(50)declare @SQLText varchar(3000)declare myCursor cursor for select top 10 DJBH from SPJHD ORDER BY DJBHopen myCursorfetch next from myCursor into @DJBHwhile @@fetch_status=0 begin print 'CategoryId='+cast(@DJBH as varchar(20)) Set @SQLText =  阅读全文

posted @ 2013-04-13 16:35 哈哈哈哈BBA 阅读(387) 评论(0) 推荐(1)

sqlserver中判断表或临时表是否存在
摘要:1、判断数据表是否存在 方法一:use yourdb;goif object_id(N'tablename',N'U') is not nullprint '存在'else print '不存在'例如:use fireweb;goif object_id(N'TEMP_TBL',N'U') is not nullprint '存在'else print '不存在' 方法二:USE [实例名] GOIF EXISTS (SELECT * FROM dbo.SysObje 阅读全文

posted @ 2013-04-13 11:54 哈哈哈哈BBA 阅读(441) 评论(1) 推荐(1)

SQL语句一键美化工具
摘要:可以自己来配置格式:Csdn 下载地址:http://download.csdn.net/detail/yilongmd/5166283 阅读全文

posted @ 2013-03-21 21:03 哈哈哈哈BBA 阅读(868) 评论(0) 推荐(0)

SQL Server 约束表字段不能有重复值
摘要:使用唯一约束语句:ALTER TABLE [Table] ADD CONSTRAINT [索引名称] PRIMARY KEY CLUSTERED ([Columns])删除用:ALTER TABLE [Table]DROP CONSTRAINT [索引名称] 阅读全文

posted @ 2013-01-17 11:14 哈哈哈哈BBA 阅读(11398) 评论(0) 推荐(0)

导航