What is the default value of an integer data type in sql server 2005?
No Answer is Posted For this Question
Be the First to Post Answer
What are null values in ms sql server?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What is sql language?
What should we do to copy the tables, schema and views from one SQL Server to another?
How many types of subqueries are there in sql server?
What is usually the first word in a sql query?
Can we do dml on views?
What is transaction ? Give me one example.
what is node in sql server?
2 Answers CarrizalSoft Technologies, Google, NIIT, Nittany, TATA,
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
Define full outer join?
Explain what is the difference between a local and a global temporary 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)