Latest Answer: For primary key if that record is being refered by some other (Child Table) sql server won't let you to delete that record.While creating relationship if you had mention "Delete Cascade" option and then if you delete the ...
It's working in MySQL but not in SQL-Server.
Latest Answer: Use a procedure which will delete record from child table first and then it will delete the same record from parent tableSame thing can be achieved using cascade delete and cascade update, this feature was not there in sql server 7.0 ...
Latest Answer: select * from sysdatabases ...
Latest Answer: Take a full backup and restore or dettach 2000 db copy .mdf and ldf to 2005 server. Attach then switch compatiblity mode to 90 then update statistics. Once you go to 2005 you can go back. ...
Latest Answer: select * into new table name from old table name where 1=0 ...
Latest Answer: Architecture is the frame work of the Database Management System. They are simply classified into logical and physical. ...
Latest Answer: We can copy the Table structure also from one table to another tableExample: CREATE table emp1 as ...
Suppose you create a students record with 5 marks, total and average.How to filter the top 3 students which are getting high average.
How to use the pivot option in MS SQL Server 2005 and How to convert the regular columns into pivoted columns explain with an example
View page << Previous 1 2 3 [4] 5 6 7 Next >>
Go Top
