mercredi 7 janvier 2015

How to set paranthesis in column name in create table Sql query


Vote count:

0




I want to create a table in Sql Server2012 which has column name which includes parenthesis as



create table temp_sp (


logtime datetime,


vcs_api varchar,


L3(S1)Status varchar,


L3(S2)Status varchar,


beam_current real,


beam_energy real,


st1_vs1_bag1_rb real,


ring_avg_pressure real


)



But when I use parenthesis with L3(S1)Status,L3(S2)Status then message Incorrect Syntax near '('.Expecting ')'or ','. is shown.How to resole it?



asked 56 secs ago







How to set paranthesis in column name in create table Sql query

Aucun commentaire:

Enregistrer un commentaire