What are the different types of cursor?
When would you use the stored procedures or functions?
when inserting to a table how many rows will be effected using triggers
If i am handling 150 servers then how to check the active jobs of all the servers?
What is it unwise to create wide clustered index keys?
How many index keys possible for a table
what is checksum in sql server.........???
What is difference between global temporary tables and local temporary tables?
What is the sql server agent?
Can you give an example of Stored Procedure?
there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C
How we create SQL Server 2005 Reporting Services ? Give me Sample
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