Do you know what is similarity and difference between truncate and delete in sql?
No Answer is Posted For this Question
Be the First to Post Answer
What are distributed partitioned views?
What is the difference between indexing and hashing?
How efficient you are in oracle and SQL server?
what type of indexes physically sort data?
Explain about thread and memory management process of SQL?
i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..
can you instantiate a com object by using t-sql? : Sql server database administration
How to drop an existing table?
How to create a dml trigger using create trigger statements?
What is difference between getdate and sysdatetime in sql server 2008?
How column data types are determined in a view?
What is difference between stored procedure and function?