If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
543how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
1086We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
897
How to find the second highest salary of an employee?
How to test a dml trigger in ms sql server?
What is a raid and what are different types of raid configurations?
Can two tables share a primary key?
Can coalesce return null?
What command is used to create a database in the sql server and how?
What are statistics?
What number sorts of privileges are accessible in sql?
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?
List the ways in which dynamic sql can be executed?
What is difference between foreign key and unique key?
what's the maximum size of a row? : Sql server database administration
How to recreate an existing index in ms sql server?
What is DCL?
What is schemabinding a view?