What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What is NOT NULL Constraint in sql server 2012?
How to create a new table in a given schema?
Why people hate cursor?
Delete duplicate rows without using rowid.
How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table?
15 Answers Leo Technologies, Mannar Company, Synechron,
What are synonyms?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
when we use function instead of procedure? plz tell me the situation with ex?
What are the mathematical functions supported by sql server 2005?
What is a collation in ms sql server?
What extended events?
in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.