Below query will return the total number of tables in sql server
Below query will return the total number of views in sql server
Below query will return the total number of stored procedures in sql server
Below query will return the total number of functions in sql server
If you want to get the names of all tables, views, stored procedures or functions then use the below queries
Using jQuery animate you can animate the controls. In this example we will see how to animate the control width using jQuery animate and toggle.
Example:Click on menu icon to animate
jQuery code to slide/animate menu bar
To take backup of dll in GAC follow the below setps.
This example shows you how to bind data to DropDownList in GridView based on the Grid Row Value. In this example we will bind the States to DropDownList based on Country in Row.
In the GridView RowDataBound we will find the DropDownList and Country then fetch the state list for the Country and bind the state list to DropDownList.
Steps to write GetJSON extension method.
When you truncate the table data, table Identity will be reset automatically. But when you delete the records in the table Identity will not be reset.
Below query will reset the table Identity in SQL server.