How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
No Answer is Posted For this Question
Be the First to Post Answer
How can you swap values between two rows in a table using single- SQL statement?
1 Answers Tavant Technologies, Virtusa,
What is a collation in ms sql server?
What is advantage data architect?
What is the use of custom fields in report?
What is save transaction and save point?
Can you use order by when defining a view?
Difference between LEN() and DATALENGTH() in sql server ?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
How many types of schemas are there?
One table how may column and Primary key
What is the sql case statement used for? Explain with an example?
A trigger can reference objects outside the current database? State true or false.
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)