How to specify the collation for a character data type in ms sql server?
No Answer is Posted For this Question
Be the First to Post Answer
Why main is user defined function?
What are pages and extents? : SQL Server Architecture
How to delete duplicate rows?
What is CTE in SQL
How to create an index on a view?
How you can get a list of all the table constraints in a database?
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.
Can some one please help with a query which will take only max value of a column in a join.
What is 2nf example?
Is sql server difficult to learn?
Determine how to use the inserted and deleted pseudo tables?
Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?
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)