Month: September 2009

Posted in Asp.Net Uncategorized

Generate Storeprocedure Dynamically

SqlConnection conn; protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { } } protected void btnConnect_Click(object…

Posted in SQL Server Uncategorized

Check IsIdentity true or false

Find SQL Table Cloumn name, data type,  column size select column_name, data_type, character_maximum_length char from information_schema.columns where…

Posted in Asp.Net Uncategorized

Find Database, Tables, Procedure Names in SQL Server

Find all database names in sql server select name from sys.databases Find all tables names in sql…