Can you please differentiate between a primary key and a unique key?
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between Drop and Truncate
Which TCP/IP port does SQL Server run on?
Can we take the full database backup in log shipping?
How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?
Which trace flags are enabled in sql server?
How many database files are there in sql server 2000?what are they?
Describe in brief databases and sql server databases architecture.
Explain what is public role in sql server?
In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2
How to check if a table is being used in sql server?
What's new in sql management studio for sql server? : sql server management studio
What is a collation in ms sql server?
Oracle (3253)
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)