Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Use of Curly braces in SQL SET Query

Author  Topic 

Chinmay2788
Starting Member

1 Post

Posted - 2014-08-18 : 13:44:51
Hello guys

I am new to SQL Programming. There's this query which is bothering me quite a bit so thought of taking help. The Query as follows:

DECLARE @end DATETIME

SET @end = {3}

I tried to read a lot of stuff regarding curly braces in SQL. Couldnt find a full proof answer. Couple of question which comes to my mind are
1) What is the use of curly brackets in the above query statement?
2) The variable is of the data type DATATIME. Why is an integer variable stored instead ?

Any help would be appreciated .
Thank you

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-08-18 : 13:50:15
Probably ODBC escape sequence:

http://msdn.microsoft.com/en-us/library/ms711838(v=vs.85).aspx
Go to Top of Page
   

- Advertisement -