Viewing 15 posts - 766 through 780 (of 1,048 total)
i want an example of converting int to time...
i cant change the datatype of column to varchar
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 4, 2012 at 6:34 am
plz give me an example..
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 4, 2012 at 6:31 am
Is there any other way to do this?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 4, 2012 at 6:18 am
when i try to do this it gives me error-
declare @date varchar(20)
select @date=CONVERT(time,convert(int,'5',1))
print @date
Msg 529, Level 16, State 2, Line 3
Explicit conversion from data type int to time is not...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 4, 2012 at 6:10 am
how can we change the collation of a table?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 4, 2012 at 4:54 am
when i tried to change collation for a column I got this error--
Expression type tinyint is invalid for COLLATE clause.
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 4, 2012 at 4:46 am
Good question...
got to know about use of prefix N...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 4, 2012 at 12:33 am
good question but confusing one....
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 4, 2012 at 12:27 am
excellent question with great discussion by gr8 ppl 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 3, 2012 at 11:41 pm
good question with great discussion 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 3, 2012 at 11:24 pm
I will try with Tally table and tally calender which Jeff has suggested....
Thnks for the suggestion 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 3, 2012 at 7:43 am
Jeff is right...
I dont have any knowledge of Tally Table..
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 3, 2012 at 5:51 am
I have created this script but looking for more optimization regarding performance--
DECLARE @count int
SET @count = 30
DECLARE @sundays int
SET @sundays = 0
DECLARE @startdate datetime
SET @startdate ='2012-01-01'
DECLARE @enddate datetime
SET @enddate =...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 3, 2012 at 3:22 am
in this case it will be '2012-02-03'
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 3, 2012 at 3:22 am
good basic question with a lot of discussion
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 3, 2012 at 3:19 am
Viewing 15 posts - 766 through 780 (of 1,048 total)