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
How do I lock a column, once records are entered into the table they can not be edited. Also how can I lock the field where only certain values are accepted?
Latest Answer: May be you can use Constraints. ...
Latest Answer: SQL Server runs on port 1433. It can be changed from the Network Utility TCP/IP properties –> Por number, both on client and the server. ...
Latest Answer: Yes, there is table partitioning in SQL Server. Unfortunately I don't know how to do that, If anyone knows that, let me know. ...
View page << Previous 1 2 [3] 4 5 6 Next >>
Go Top
