|
|
-
Madhivanan Posted 5 Months ago through Blogs
In Query Analyser, set the result mode to Text (Press CTRL+T), execute the following code and see the result. set nocount on
select
space(total-len(replicate(char(characters),no)))+ replicate(char(characters),no*2-1)
from
(
...
|
-
Madhivanan Commented 5 Months ago through Blogs
Thanks Joe Celko for this information....
|
-
Madhivanan Commented 5 Months ago through Blogs
Joe Celko, Thanks for your reply. But as per ISO 8601, the time is seperated using time seperator T if dahses are used. References are http://en.wikipedia.org/wiki/ISO_8601 and http://www.w3.org/TR/NOTE-datetime. In SQL Server YYYY-MM-DD HH:MM:SS witho...
|
|
|
-
Madhivanan Posted 5 Months ago through Blogs
Often I see lot of SQL deveopers complaining about the error when using datetime values in their queries. The common error that almost everyone would heard about is "Conversion failed when converting date and/or time from character string."
But in gener...
|
-
Madhivanan Liked 5 Months ago through Blogs
Someone in the forums asked about the internal storage of the temporary table. The questioner was complaining that the table was not stored in the database
Let us consider this example
create table #t(i int)
Now check the existance of the table in...
|
-
Madhivanan Liked 5 Months ago through Blogs
In this post, we see that temporary tables allow the use of only 116 characters out of a possible 128. How are temporary tables named, and what happens to the restricted length of 12 characters? What is the naming logic for temporary tables?...
|
|
|
-
Madhivanan Commented 5 Months ago through Blogs
Readers may find this interesting too http://beyondrelational.com/modules/2/blogs/70/posts/10940/internal-storage-of-temporary-table-names.aspx Also make sure to read comments as well...
|
-
Madhivanan Commented 5 Months ago through Blogs
Congratulations Nakul. Go for 1000 posts in 2015 :)...
|