Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?


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

Post New Answer

More SQL Server Interview Questions

How to list all dsn entries on your local machine using odbc_data_source()?

0 Answers  


What kind of problems occurs if we do not implement proper locking strategy?

0 Answers  


What is a non-clustered index?

0 Answers  


How to delete exactly duplicate records from a table?

0 Answers  


what is statistics

1 Answers  






What is triggers and its types?

0 Answers  


Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?

1 Answers  


Tell me what do you mean by an execution plan? Why is it used? How would you view it?

0 Answers  


What is a subquery in a select query statement in ms sql server?

0 Answers  


can you any body tell me which service pack is installed in the sql server?

3 Answers  


What is the difference between upgrade and migration in sql server?

0 Answers  


Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,


Categories