sqlserver ´æ´¢¹ý³ÌÈçºÎ¶¯Ì¬µÄÉùÃ÷ ±äÁ¿
create procedure test
as
declare @var_0 varchar(100)
declare @cc int
set @cc=0
exec('select @var_'+@cc +'=fullName from contact')
go
exec test
Ö´Ðиô洢¹ý³ÌµÄʱºò »á±¨@var_0 δÉùÃ÷
ÇëÎʸ÷λ´óÏÀ£¬£¬Õâ¸ÃÈçºÎ´¦Àí £¬£¬£¨ÕâÖ»ÊDzâÊÔ£¬£¬ÎÒ×îºóÊÇÏ붯̬µÄÉùÃ÷±äÁ¿£¬ÔÙ¶¯Ì¬µÄ¸øÆ丳ֵ£©
¶¯Ì¬ÉùÃ÷±äÁ¿£¬±äÁ¿Ò²Ó¦¸ÃÉùÃ÷ÔÚEXECÀïÃ棬
@var Õâ¸öÊÇûÓÐÉùÃ÷µÄ¡£
ÓÃ
SP_EXECUTESQL
SQL code:
Alter procedure test
as
--declare @var_0 varchar(100)
declare @cc int
set @cc=0
exec(' declare @var_0 varchar(100) select @var_'+@cc +'=fullName from contact')
go
exec test
declare @cc int
set @cc=0
exec('
declare @var_0 varchar(100) select @var_'+@cc +'=fullName from contact')
SQL code:
Êä³ö²ÎÊý
declare @num int,
@sqls nvarchar(4000)
set @sqls='select count(*) from tableName'
exec(@sqls)
--ÈçºÎ½«execÖ´Ðнá¹û·ÅÈë±äÁ¿ÖУ¿
declare @num int,
@sqls nvarchar(4000)
set @sqls='select @a=count(*) from tableName '
exec sp_executesql @sqls,N'@a int output',@num output
select @num
ÎÒÖ÷ÒªÊÇÏëÏȶ
Ïà¹ØÎÊ´ð£º
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥ÁË°¡£¿
......
СµÜÏÖÔÚSwingÔÚÁ¬½ÓÊý¾Ý¿âÉÏÓöµ½Ò»µãÎÊÌ⣬ÇëÎÊSwingÀïÃæµÄʼþºÍSQLserverÊý¾Ý¿âµÄÁ¬½ÓÓÐʲôºÃµÄ×ÊÁÏÊéÍƼöÂð£¿
Õâ¸öÓ¦µ±Ã»ÓÐʲôÌرð,ÓëÆäËûµÄ±à³ÌÒ»Ñù.
JDBC
ÇëÎÊÔÚSwingÖмÓÔر³¾°Í¼Æ¬ÊÇÔõô¼ÓµÄ£¿
......
´ÓÍøÉϲ鵽µÄ×ÊÁÏ˵£¬ÈκÎÊý¾ÝÀàÐÍÓëNULLÖµ½øÐмÆË㣬½á¹û¶¼½«ÎªNULL.
select null-1
½á¹ûÊÇnull
¿ÉÊÇÏÂÃæÕâ¸ö²éѯΪʲô»á³ö´íÄØ£¿
select isnull(null-1,'test');
¾ÓÈ»±¨´í˵½«varcharתΪintʧ°Ü¡£
Ϊʲô» ......
Êý¾ÝÒÔ´óÎļþµÄ·½Ê½£¬´æÔÚÊý¾Ý¿âÖС£Îļþ´óС²»Ò»Ö£¬Óм¸°ÙKµÄ£¬Ò²ÓÐ1G¶àµÄ¡£Îļþ¸ñʽ²»Í³Ò»£¬ÓÐZIP£¬RAR£¬DWG£¬WPSµÈµÈ¡£
ÏÖÔÚÏë°Ñ´óÎļþµ¼³öµ½¾ÖÓòÍøÄÚµÄһ̨µçÄԵĹ²ÏíÎļþ¼ÐÄÚ£¨ÎÞSQL SERVER£¬ÓÐÓû§Ãû¼ ......
ÎÒÒ»¸öÏîÄ¿ÀïÒªÁ¬½ÓSQLserverºÍORACLEÁ½¸öÊý¾Ý¿â£¬
·â×°ÀàÀïÃæÓõÄÊÇusing System.Data.OleDb; £¨±¾ÈËÓõÄÊÇC#£©
ÏëÄDzÙ×÷ÕâÁ½¸öÊý¾Ý¿âµÄÀà·â×°ÔÚÒ»Æ𣬠ÈçºÎ×öÄØ£¿ ÓÐûÄÄλÓÐдºÃÁ˵ģ¿
Óù¤³ ......