Why is the need for data conversion transformations?
No Answer is Posted For this Question
Be the First to Post Answer
What is pessimistic concurrency?
Where is my database stored on the hard disk in ms sql server?
How to turn on the mssql api module in php?
Explain the ways to controlling cursor behavior?
system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??
How would we use distinct statement? What is its use?
Explain cursor as data base object?
Can you explain some of the DTS problems?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
Explain the properties of subqueries in sql server?
Can we create clustered index on non primary key column
20 Answers ABC, CTS,
What is wide table?
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)