|
|
-
Jason Yousef Commented 7 Months ago through Just Learned | 1 Point
Just to add...Variable's names' are case sensitive too.......
|
-
Jason Yousef Posted 12 Months ago through Just Learned | 5 Points
Fast parse supports the following string formats for date, YYYYMMDD and YYYY-MM-DD
Basic and extended formats for a four-digit year, a two-digit month, and a two-digit day, for the extended format, the date parts are separated by a hyphen (-), also it's...
|
-
Jason Yousef Posted 12 Months ago through Just Learned | 5 Points
Fast parse supports the following string formats for date, YYYYMMDD and YYYY-MM-DD
Basic and extended formats for a four-digit year, a two-digit month, and a two-digit day, for the extended format, the date parts are separated by a hyphen (-), also it's...
|
-
Jason Yousef Posted 12 Months ago through Just Learned | 5 Points
Fast parse supports the following string formats for date, YYYYMMDD and YYYY-MM-DD
Basic and extended formats for a four-digit year, a two-digit month, and a two-digit day, for the extended format, the date parts are separated by a hyphen (-), also it's...
|
-
Jason Yousef Posted 12 Months ago through Just Learned | 5 Points
Fast parse supports the following string formats for date, YYYYMMDD and YYYY-MM-DD
Basic and extended formats for a four-digit year, a two-digit month, and a two-digit day, for the extended format, the date parts are separated by a hyphen (-), also it's...
|
-
Jason Yousef Learned 12 Months ago through Just Learned | 1 Point
At one point, I created a demo script whereby one could retrieve the next value in a SQL Server 2012 sequence and use that value in a UNION ALL clause. That worked up to and including CTP 3. It never worked with plain UNION. I never tested it on RC0,...
|
-
Jason Yousef Learned 12 Months ago through Just Learned | 1 Point
At one point, I created a demo script whereby one could retrieve the next value in a SQL Server 2012 sequence and use that value in a UNION ALL clause. That worked up to and including CTP 3. It never worked with plain UNION. I never tested it on RC0,...
|
-
Jason Yousef Liked 12 Months ago through Just Learned | 1 Point
I learned about this from Pinal Dave's blog(You can see the original article in references.)
In SQL Server, while creating a table, we can give maximum length of 128 characters. However, while creating temp tables, maximum length can be of 116 chara...
|
-
Jason Yousef Learned 12 Months ago through Just Learned | 1 Point
I learned about this from Pinal Dave's blog(You can see the original article in references.)
In SQL Server, while creating a table, we can give maximum length of 128 characters. However, while creating temp tables, maximum length can be of 116 chara...
|
-
Jason Yousef Liked 12 Months ago through Just Learned | 1 Point
I learned about this from Pinal Dave's blog(You can see the original article in references.)
In SQL Server, while creating a table, we can give maximum length of 128 characters. However, while creating temp tables, maximum length can be of 116 chara...
|