-
SQL Server Insert and Delete
1. how to insert five rows in a table using single query(in ms-sql or oracle)2.how to delete duplicate values in a table. for example, the table containing five duplicate values(like name rani). i would like to delete all four rows in a table. but not the one row.
-
Fetching records from attributes
How will you fetch records having underscore ( _ ) in the middle of of strings, from columns having attributes as "amit_6", "t_mit06", "am_06", "m_t", "j_x_t" ?
-
Stored Procedure Performance Tuning
How can we improve stored procedure performance? Explain the performance tuning techniques.
-
Unique Key in SQL Server
How To Define Unique Key in SQL Server
-
Define Unique Key in SQL Server
How to define unique key in table? Is it possible to define one primary key and one unique key in a single table?
-
To display list of tables in database
How to display list of tables from a particular database in MS-SQLHow to display description of that particular table?
-
-
-
What is DESCRIBE command in SQL Server?
What is its purpose?How to use it?
-
-