jagadeep's profileWelcome to jagadeep's s...PhotosBlogListsMore  |  Tools Help |
|
|
February 10 To Copy a table from one database to another or within the Database in SQL Server 2005 >>If you have a table in a database and you would like to copy the table to another database, then use this query Executing the above query will copy your table to a new database.
Just remember that using this query will only transfer the schema and data. It does not transfer the indexes, foreign keys. If you want to transfer all the objects from one database to another, open Sql Server Management Studio > Right click on your database > All Tasks > Generate SQL Scripts. Then run these scripts against the new database.
To Transfer both schema and data To copy both data and schema, use the Microsoft SQL Server Database Publishing Wizard 1.1.
This tool works for both SQL 2000 and SQL 2005 and generates a single SQL script file which can be used to recreate a database (both schema and data).
To Set the Cursor Focus to a Textbox when the page loads >>To set the Cursor Focus to a Textbox when the page loads, just a piece of code in your Page_Load this.Page.Form.DefaultFocus = TextBoxID.ClientID; Count Number of User CreatedTables in SQL Server Database >>Here is a simple query to find/count the number of user created tables in a particular database in SQL Server. SELECT COUNT(*) from information_schema.tables WHERE table_type = 'base table' Fashion Song >> Hello Mr.SeethamRajuShivaArun, here is the song you requested MARJAWA Java Query >> The latest version of java Query ie., jquery-1.3.1.min.js has been released. you can download it here.. |
|
|
