How to provide default values to function parameters?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

Explain the basic concepts of SQL server architecture?

2 Answers   College School Exams Tests,


What is an index?

8 Answers   Yardi Software,


i have a table like this Eno ename 1 a 2 b 3 c i want to display ename and bossname from table hint boss is also an employee

3 Answers   NIIT,


What is row_number () and partition by in sql server?

0 Answers  


How to create an identity column?

0 Answers  


Difference between group by clause and having clause in SQL?

0 Answers   Flextronics,


Explain the cursor lock types?

0 Answers  


How to create logins using windows Authentication mode?

2 Answers  


How optimize sql query with multiple joins in sql server?

0 Answers  


How do I open port 1433?

0 Answers  


how you can list all the tables in a database?

0 Answers  


In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,


Categories