How to test values returned by a subquery with the in operator?
No Answer is Posted For this Question
Be the First to Post Answer
What is transaction server implicit?
Do you know what is difference between stored procedure and user defined function?
What is the appropriate number of test cases that you can write on a database?
can we call functions from stored procedure in SQL Server 2005 ? How?
what is the system function to get current user's user id? : Sql server database administration
how to get the automatic backup of the database in the sql server
What is the use of stored procedure?
How to define and use table alias names in ms sql server?
what happens on checkpoint? : Sql server database administration
What is exclusive locks?
I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...
could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)