What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -
how to copy only distinct data into another table which is not already exist in database?
How to create function with parameter in sql server?
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..
Explain the etl (extraction, transformation, and loading)?
What do you mean by sql server agent?
In what sequence sql statement is processed?
What is tablesample?
What is nolock?
What do you mean by data integrity?
What are the joins in sql server? : sql server database administration
What is inner join in sql server joins?