What is the difference between SQL notification and SQL invalidation?
No Answer is Posted For this Question
Be the First to Post Answer
Is sql server is free?
What is the command used to get the version of sql server?
How to provide values to stored procedure parameters in ms sql server?
Magic Tables ?
Explain about local stored procedure?
Explain the types of indexes.
How we Resize table,temp table, database and log file size in SQL Server 2005
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
Is the primary key column of a table an index in ms sql server?
How to create a view with data from multiple tables?
What is intellisense?
Introduction of rollup clause using sum and group by clause?
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)