How to check if stored procedure is running in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
Is sql server a database?
what is call by value & call by reference ?
one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.
Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.
Can you tell me the difference between DELETE & TRUNCATE commands?
How to insert new line characters into strings?
What is difference between aggregate and analytic function?
Is it possible to have clustered index on separate drive from original table location?
Explain the stored procedure?
What is a unique key constraint?
How much is a sql server license?
explain different types of jions with examples briefly?