Database

LEARN_FOR_EVER wrote:

help help help help h e l p

LEARN_FOR_EVER wrote:

How can i get the date of the day of the system

select Password <br />
from tblUser <br />
where username='User1' and cast(password as binary)=cast('Password' as binary)

declare @cTest1 varchar(10)
declare @cTest2 varchar(10)

select @cTest1 = 'test'
select @cTest2 = 'Test'

if (@cTest1 = @cTest2)
	print 'They are equal as varchar'
else
	print 'They are NOT equal as varchar'

if (cast(@cTest1 as binary) = cast(@cTest2 as binary))
	print 'They are equal as binary'
else
	print 'They are NOT equal as binary'

<br />
select  Convert(DATETIME, '17/01/2006 14:52:48')<br />

<br />
select  Convert(DATETIME, CAST(Day(getdate())as char(2)) + '.' + CAST(Month(getdate()) as char(2)) + '.' + CAST(Year(getdate())as char(4)) , 104)<br />

CREATE PROCEDURE GetRandomRow AS

declare @nRand int
declare @cSQL varchar(200)

select @nRand = 1 + (rand() * (select count(*) from MyTestTable))

select @cSQL = 'SELECT TOP 1 * FROM (SELECT TOP ' + cast(@nRand as varchar) 
  + ' * FROM MyTestTable ORDER BY IDColumn ASC) as tbl ORDER BY IDColumn DESC'

exec(@cSQL)