Month: September 2009
Generate Storeprocedure Dynamically
SqlConnection conn; protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { } } protected void btnConnect_Click(object…
September 24, 2009
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…
September 24, 2009
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…
September 22, 2009