Stack Exchange
log in
help
Stack Exchange Data Explorer
Home
Queries
Users
Compose Query
rene
Registered User
member for
4059 days
seen
Sep 15 at 6:55
website
rene.bloggingabout.net
location
This space is for rent!
edited
favorite
recent
Profile spammers Stack Apps
Fetching posts in a given month with row_number
select convert(datetime, dateadd(d,1,eomonth(getdate())))
select * from sys.indexes
declare @month datetime = '##Year##-##Month##-01' declare...
create table #users(accountid int, name nvarchar(150), fi...
create table #users( date date, count int); insert into...
select case when reputation % 2 = 0 then -log10(reputatio...
select reputation from users where reputation % 2 = 0
/*select * from sede_sites select * from sede_databases...
sede_ineachdb ' select [$site_name$] site , count(*) [cou...
select * from comments where text like 'Does this%'
select site_name , initialized , made_available , notes f...
select * from sys.databases where name like '%_Temp'
create table #result (site sysname , hostname sysname , o...
1
2
3
4
5
…
207
next
Data Explorer works best with JavaScript enabled