2D Game with Unity 3D

February 20, 2013 Leave a comment

Short tutorial for building 2D game on Unity 3D, click here to download

Add role member using tsql in mssql 2000

January 17, 2013 Leave a comment
EXEC sp_grantdbaccess 'jeff', 'jeff'
EXEC sp_addrolemember 'Sales_Managers', 'Jeff'
Categories: SQL Tags: , , , , ,

Get User Member from Spesified Role using T-SQL

January 17, 2013 Leave a comment
declare @uidrole as int
declare @rolename varchar(20)
set @rolename='role_name'
select @uidrole=uid from dbo.sysusers where name =@rolename
select * from dbo.sysusers where gid=@uidrole
Categories: SQL Tags: , , , , , ,

Grant non sa user to create function on mssql 2008 r2

November 24, 2012 3 comments
GRANT ALTER ON SCHEMA::dbo TO user_biasa
Categories: SQL Tags:

Restore BAK file on MSSQL 2008 R2

November 22, 2012 Leave a comment
alter database db1
set single_user with
rollback immediate
restore database db1
from disk ='d:\db_backup_2012_11_20_235900_7740000.bak'
with move 'db_data' to 'i:\db.mdf',
move 'db_log' to 'i:\db_log.mdf',
replace
Categories: SQL

Format Currency Rupiah di C#

November 22, 2012 Leave a comment
CultureInfo culture = new CultureInfo("id-ID");
row["angka"] = Decimal.Parse(
row["angka"].ToString()).ToString("C", culture);
Categories: C#

Get User, Password and SID on MSSQL 2008 R2

select 'exec sp_addlogin['+name+'],',password_hash,',@sid=',sid,',@encryptopt=skip_encryption' from sys.sql_logins
Categories: SQL