Do you know what is user defined datatypes and when you should go for them?
No Answer is Posted For this Question
Be the First to Post Answer
how can i view structure of table in sql server? tell me that query.
Can you type more than one query in the query editor screen at the same time?
What happens if the update subquery returns multiple rows in ms sql server?
Can we passed multiple recordset(set of records) using a Stored Procedure
What is use of except clause? How does it differ from not in clause?
What is Right Outer Join?
What is Index ? Explain its Types?
Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?
Can we update data in a view?
what is a transaction and what are acid properties? : Sql server database administration
What is sql server schema compare? How we can compare two database schemas?
What are SQL Jobs, please mention the use of it and how to create them.
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)