What are the tables in sql?
About types of indexes in SQL server ?
What are the advantages of paper records?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
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
How you can change a cross join into an inner join?
What are the dmvs?
How to declare a cursor with "declare ... Cursor" in ms sql server?
Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?
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..
What is a rownum?