pymssql语法错误

Question

sql='insert into Member(User_Name) VALUES(%(User_Name)s)'

curs.execute(sql,(self.user_Name))

报错：pymssql.ProgrammingError: (102, "Incorrect syntax near '('.DB-Lib error message 20018, severity 15:nGeneral SQL Server error: Check messages from the SQL Servern")

near '('         这个(是指的insert into Member(这个括号   我的参数风格是pyformat

Answer 1

引用来自“pitttttttt”的评论

应该是
'insert into Member(User_Name) VALUES("%(User_Name)s")'

Answer 2

应该是
'insert into Member(User_Name) VALUES("%(User_Name)s")'

Answer 3

sql 值多少