|
|
|
|
|
|
-
Madhivanan Commented 6 Months ago through Blogs
Thanks for your feedback dishdy...
|
-
Madhivanan Commented 6 Months ago through Blogs
Thanks Balakrishna. Wishing you the same...
|
|
|
-
Madhivanan Posted 6 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 Posted 6 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 6 Months ago through Blogs
Thanks Joe Celko for this information....
|
-
Madhivanan Commented 6 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...
|
|
|