Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
No Answer is Posted For this Question
Be the First to Post Answer
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 ...."??
What is the openxml statement in sql server?
Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.
1 Answers Cognizant, HCL, Value Labs,
What is serializable?
What is microsoft sql server?
What is a primary key?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
What is the difference between a check constraint and a rule?
What is sql stored procedure?
Explain what are partitioned views and distributed partitioned views?
what do you understand by change data capture?
How to truncate the log in sql server 2012? : sql server database administration
Oracle (3253)
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)