How to insert data into an existing table?
No Answer is Posted For this Question
Be the First to Post Answer
What is primary key and example?
can we give the identity for existing column of the table? (already table contains 10(1-10) unique randam records)
What do you mean by a Composite primary key?
Does full backup break log chain?
hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
What is logon trigger?
How to throw custom exception in Stored Procedure?
How to create a large table with random data for index testing in ms sql server?
When do u use clustered index and non-clustered index?
What are different types of raid levels?