FilipDeVos

# .gitignore for .NET projects
# Thanks to Derick Bailey
# http://www.lostechies.com/blogs/derickbailey/archive/2009/05/18/a-net-c-developer-s-gitignore-file.aspx
# Additional Thanks to 
# - Alexey Abramov

# Standard VS.NET and ReSharper Foo
obj
bin
*.csproj.user

FilipDeVos

""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
" options for gvim on Windows 7
" 
" Author: Filip De Vos
" Last updated: 1st April 2010 
" 
" To use this conveniently I work like this: 
"  - check out the gist in my Git working folder with:
"      cd ~/Documents/WorkingGit/
"      git clone git://gist.github.com/258688.git vimconfig

FilipDeVos

@echo off

FOR /D %%I in (*) DO (
echo Installing hooks in %%I
copy pre-revprop-change.bat %%I\hooks\ /Y
copy pre-commit.bat %%I\hooks\ /Y
)

FilipDeVos

DECLARE @mynumber INT
      , @padding  INT 

SELECT @mynumber = 123
     , @padding = 8
SELECT REPLACE(STR(@mynumber, @padding), ' ', '0')

FilipDeVos

exec xp_msver 'ProductVersion'

FilipDeVos

select @@version

FilipDeVos

select serverproperty('productversion')

FilipDeVos

select @@microsoftversion / 0x01000000 

FilipDeVos

SELECT CASE @@microsoftversion/ 0x01000000 
         WHEN 8 THEN 'sql 2000'
         WHEN 9 THEN 'sql 2005'
         WHEN 10 THEN 'sql 2008'
         WHEN 11 THEN 'sql Denali'
       END

FilipDeVos

create database identity_insert_test
GO
use identity_insert_test
exec sp_addlogin 'SimpleLogin', 'PasswordForSimpleLogin'
GO
exec sp_grantdbaccess 'SimpleLogin', 'SimpleLogin'
GO

if object_id('dbo.a') is not null
   drop table dbo.a