Filip De Vos FilipDeVos

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

## _gvimrc
""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
" 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

## install-hooks.bat
@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
)

## numeric_padding.sql
DECLARE @mynumber INT
      , @padding  INT

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

## xp_msver.sql
exec xp_msver 'ProductVersion'

## @@version.sql
select @@version

## serverproperty.sql
select serverproperty('productversion')

## @@microsoftversion.sql
select @@microsoftversion / 0x01000000

## @@microsoftversion_query.sql
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

## identity_insert_01.sql
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
	# .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
	""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
	" 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
	@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
	)
	DECLARE @mynumber INT
	, @padding INT

	SELECT @mynumber = 123
	, @padding = 8
	SELECT REPLACE(STR(@mynumber, @padding), ' ', '0')
	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
	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