Do you know what is similarity and difference between truncate and delete in sql?
What types of integrity are enforced by a foreign-key constraint
What are subquery and its properties?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
What guidelines should be followed to help minimize deadlocks?
What happens if time-only values are provided as date and time literals?
What is difference between index and primary key?
What is join and name different type of joins?
What is the purpose of indexing?
What is side by side migration in sql server?
can we call functions from stored procedure in SQL Server 2005 ? How?
What is the role that is required for killing a process What is the role that is required for creating a linked server
1 Answers CarrizalSoft Technologies, IBM,
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