How to create new table with "create table" statements?
No Answer is Posted For this Question
Be the First to Post Answer
Explain transaction server auto commit?
What is the recommended total size of your memory optimized tables?
What is the dbcc command and why is it used?
Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?
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.
Where is localdb stored?
I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?
What are various aggregate functions that are available?
How to encrypt Strored Procedure in SQL SERVER?
How to convert a table data in XML format in sql server?
Explain system scalar functions?
Do you know what is openxml in sql server?
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)