How dts is used to extract, transform and consolidate data?
Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?
What all db objects can be found in MSDB database of a SQL Server instance?
What is partition, how will you implement it? : sql server analysis services, ssas
Write query to return all rows sql?
Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product
What are the different types of lock modes in sql server 2000?
How to use user defined functions in expressions?
What is transaction server distributed transaction?
What is normalization according to you and explain its different levels?
Explain sql delete command?
how to change column into row in sql
query processing