How to how to convert numeric expression data types using the convert() function??
No Answer is Posted For this Question
Be the First to Post Answer
What is the server name in sql server?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
Detail about the hardware which is supported by SQL server?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
How self join is different from outer join?
What is a stored procedure?
What is 2nf normalization form?
Where is my database stored on the hard disk in ms sql server?
What are the different type of replication in sql server?
how insert selected column only ?
What is a partition key?
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
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)