Code Master - A reference guide for programmer's

Code Master - A reference guide for programmer's

Programming is fun and interesting. As you all know, sometime we programmers stucks in the middle way of coding without getting a solution. Blogs like this will help us to find a path to solve our problems. The contents of this blog are the solutions that I found by myself and from other sources. Sharing such solutions is also interesting. Thank you!

Thursday, February 26, 2015

SQL Query to Backup all the databases in SQL 2008

DECLARE @name VARCHAR(50) -- database name DECLARE @path VARCHAR(256) -- path for backup files DECLARE @fileName VARCHAR(256) -- ...

Thursday, February 19, 2015

Disable and Enable all the constraints in a SQL database

Disable all the constraint in database EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all" Enable all the con...

Wednesday, February 18, 2015

How to set a default button for div

Using this code onkeypress="return WebForm_FireDefaultButton(event, '<%=ButtonName.ClientID %>')" Example ...

Sunday, February 8, 2015

Add a column, with a default value, to an existing table in SQL Server

Syntax ALTER TABLE {TABLENAME} ADD {COLUMNNAME} {TYPE} {NULL|NOT NULL} CONSTRAINT {CONSTRAINT_NAME} DEFAULT {DEFAULT_VALUE} ...

View web version

Powered by Blogger.