I have a table named 'EMP', with records like Emp_id Dept Name 10 Mech Sania 20 Elect Priya 30 IT Riya Now i want the result to be displayed like the string value "Test" should be inserted before these set of data like shown below. Test 10 Mech Sania Test 20 Elect Priya Test 30 IT Riya...

Hi Techies, We are using Visual Studio 2005, Sql Express in our Windows application. When the user try to delete the rows from the table from front end , It throws error like this "Unable to find index entry in index ID 2, of table 452196661, in database 'test'. The indicated index is corrupt...

Hi, Can I have the T-SQL query for the following scenario. I have the following set of 3 tables with the values and the desired output is as below : create table cars (carid int, carname varchar(100)) ; create table Styles (Styleid int, Style varchar(100)) create table carStyles (carid int, Styleid int...

Hi, Can I have the T-SQL query for the following scenario. I have a table with the following list of values and the desired output is as below : create table foo(c int) go insert into foo values (11) insert into foo values (27) insert into foo values (83) insert into foo values (24) go Desired output...

Look at the INFORMATION_SCHEMA.TABLE_PRIVILEGES .