2013年5月29日
SQLServer : EXEC和sp_executesql的区别
摘要： http://www.cnblogs.com/xbf321/archive/2008/11/02/1325067.htmlUSE [DBCordBlood]GO/****** Object: StoredProcedure [dbo].[GetIntKey] Script Date: 05/29/2013 10:44:58 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[GetIntKey]@KeyName nvarchar(50), @KeyValue int OUTPUTASBEG... 阅读全文
posted @ 2013-05-29 10:48 .NET Fans 阅读(86) 评论(0) 推荐(0)
全局表应用
摘要： USE [DBCordBlood]GO/****** Object: StoredProcedure [dbo].[GetIntKey] Script Date: 05/29/2013 10:23:08 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[GetIntKey]@KeyName nvarchar(50), @KeyValue int OUTPUTASBEGIN declare @sql nvarchar(max) set @sql = '' SELECT @sql = 阅读全文
posted @ 2013-05-29 10:26 .NET Fans 阅读(147) 评论(0) 推荐(0)