How many types of local tables are there in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
what is bit data type? and what are the information that can be stored inside a bit column?
How do I find query history in sql server?
What is sql injection? How to protect against sql injection attack?
Explain about system database?
In what version of sql server were synonyms released?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
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.
How do I find the sql server database version?
What is transaction server implicit?
Mention the different types of replication in sql server.
how to give input dynamically to a insert statement in sqlserver
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)