How to execute a stored procedure in ms sql server?
How to automatically create a log when an exception is being received into SQL Server?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
Explain the difference between primary keys and foreign keys?
How to get the number of affected rows?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
Which is the best place or learning center for MS SQL?????In Bangladesh?????
What is the main difference between ‘between’ and ‘in’ condition operators?
What do you understand by a view?
Do you know what is normalization of database? What are its benefits?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
How to create function with parameter in sql server?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
Define self join in sql server joins?
What is dbcc? Give few examples.
