aF
|
Registered User
|
- declare @test varchar(10) select @test = 'ã' select @test
- declare @value varchar(40) select @value = 'It''s a good...
- select getdate()
- select datename(dw, datepart(dw, getdate()))
- select distinct PostTypeId from Posts
- create table #final ( id int, val1 varchar(20), val2 varc...
- select count(test) as cnt, substring(test, patindex('%[^0...
- select 3/2.0
- select (1.0*3)/2
- query
- create table #test ( ID int, Description varchar(20) ) ...
- create table #tablename ( ID int, Type varchar(1), Versio...
- join example
- create table #customer ( id int not null primary key iden...
- create table #customer ( id int not null primary key iden...