i want an example of converting int to time...

i cant change the datatype of column to varchar

plz give me an example..

Is there any other way to do this?

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...

@anthony-2,

how can we change the collation of a table?

when i tried to change collation for a column I got this error--

Expression type tinyint is invalid for COLLATE clause.

Good question...

got to know about use of prefix N...

good question but confusing one....

excellent question with great discussion by gr8 ppl 🙂

good question with great discussion 🙂

I will try with Tally table and tally calender which Jeff has suggested....

Thnks for the suggestion 🙂

Jeff is right...

I dont have any knowledge of Tally Table..

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 =...

in this case it will be '2012-02-03'

good basic question with a lot of discussion