Differentiate between truncate vs delete in mssql?
No Answer is Posted For this Question
Be the First to Post Answer
What is a unique index?
Why do we use non clustered index?
What is dbcc? Give few examples.
Explain the difference between cross join and full outer join?
explain different types of constraints? : Sql server database administration
Who developed sql server?
What is create command?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
What are the restrictions that views have to follow?
what is the query and condition to delete datas in sql server.
Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?
One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h
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)