Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

sql query with an alias having space in asp.net code behind

2 Posts 2 Posters 0 Views 1 Watching

U Offline
U Offline
User 11886269

wrote on last edited by

#1

when writing sql query in aspx file having alias with space I:e select emp_no as " emp no" working fine in database but giving syntax error when i run the same query in .aspx page of asp.net which is code behind file..how to resolve this issue? Thanks
F 1 Reply Last reply

0
U User 11886269

when writing sql query in aspx file having alias with space I:e select emp_no as " emp no" working fine in database but giving syntax error when i run the same query in .aspx page of asp.net which is code behind file..how to resolve this issue? Thanks
F Offline
F Offline
F ES Sitecore

wrote on last edited by

#2

Put brackets around the alias; "select emp_no as [emp no] from ..."
1 Reply Last reply

0

Log in to reply