注册 登录
编程论坛 SQL Server论坛

怎么在SQL在加上'这个符号

uatoily 发布于 2007-12-04 21:10, 1653 次点击
怎么在sql 中加上' 或者"
5 回复
#2
purana2007-12-04 21:22
select '''','"'
#3
uatoily2007-12-04 21:34
exec('insert '+@tbName+' values('+@AddID+'","'+@Name+'","'+@Sex+'","'+@Birthday+'","'+@UserID)+'")'
我这样加的...感觉好多错...帮加改下...
我就是想要 [email=]'+@AddID+'[/email] 的这种..可是'要怎么显示?

[[italic] 本帖最后由 uatoily 于 2007-12-4 21:36 编辑 [/italic]]
#4
XieLi2007-12-05 11:29
--DROP TABLE #T
CREATE TABLE  #T (ID VARCHAR(10) ,FYJE VARCHAR(10) ,TDBH  VARCHAR(10),DATE1 DATETIME)
declare @tbName varchar(10),@Name varchar(10),@Sex varchar(10),@AddID varchar(10),@SQL VARCHAR(100),@DATE VARCHAR(20)
SET @tbName='#T'
SET @AddID='1'
SET @Name='谢颖'
SET @Sex='女'
SET  @DATE='2007-10-11'
exec('INSERT INTO '+@tbName+' VALUES (CONVERT (INT,'''+@AddID+'''),'''+@Name+''','''+@Sex+''',CONVERT (DATETIME,''' + @DATE +'''))')
SELECT * FROM #T


试一下!

[[italic] 本帖最后由 XieLi 于 2007-12-5 11:32 编辑 [/italic]]
#5
uatoily2007-12-05 14:41
......LS的很好..很强大啊...看来要好好学习了
#6
purana2007-12-05 14:46
嘿嘿..学习..
1