Hi I installed SQL Server R2 on my local machine(office laptop) yesterday It was ok yesterday. I created sample Databases and have done few DTS and...
Hi, I have 4 views on my database on SQL Server 2008 R2, Its really taking more time to execute these views. How Can I Make the views to execute...
I have a .txt file, I am suppose to put the data in the .txt file into a table in a database. I generally deal such type of task using Import Export...
When I need to create a ‘View’ from the columns of different tables in a Database, Is it necessary that the tables involving in that view should...
There is a SQL Server Instance-1....With a Database-1....haveing 6 tables Among which 3 of the tables have to be shared by Another SQL Server...
How Can I get the ERD of a database created (with new tables) in Sql Server 2008 using SSMS
I have a 'Root' table with 8 columns. First 5 columns in 'Root table ' are used in all 10 child tables of that root table. I first wanted to make the...
I have a 'Root' table with 8 columns. First 5 columns are to be declared as a Primary key(Composite). And I have 10 to 15 tables, each with a...
Separate names with a comma.
