|
|
-
Alpesh Patel Learned 4 Days ago through Just Learned
T-SQL's ISNUMERIC() function has a problem. It can falsely interpret non-numeric letters and symbols (such as D, E, and £), and even tabs (CHAR(9)) as numeric.
...
|
-
Alpesh Patel Liked 4 Days ago through Just Learned
T-SQL's ISNUMERIC() function has a problem. It can falsely interpret non-numeric letters and symbols (such as D, E, and £), and even tabs (CHAR(9)) as numeric.
...
|
-
Alpesh Patel Learned 19 Days ago through Just Learned
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 i...
|
-
Alpesh Patel Liked 19 Days ago through Just Learned
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 i...
|
-
Alpesh Patel Learned 22 Days ago through Just Learned
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...
|
-
Alpesh Patel Liked 22 Days ago through Just Learned
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...
|
-
Alpesh Patel Liked 23 Days ago through Blogs
Just thought of sharing the actual results to show is it better to use Lookup or Merge Join....
|
-
Alpesh Patel Learned 1 Months ago through Just Learned
I just stumbled across a weird misconception that I'd like to help you to avoid:
If you consume the results of a (non-inline) table valued function, the results are not in the same order as if you take the content óf the TVF in your query.
So, if yo...
|
-
Alpesh Patel Liked 1 Months ago through Just Learned
I just stumbled across a weird misconception that I'd like to help you to avoid:
If you consume the results of a (non-inline) table valued function, the results are not in the same order as if you take the content óf the TVF in your query.
So, if yo...
|
-
Which Key Constraints enforces Enitity Integrity ,Referential Integrity and Domain Integrity?...
|