Why should you use or avoid select * statements?
No Answer is Posted For this Question
Be the First to Post Answer
which one will take 1st priority in case of insert statement and select statement???
Mention the different types of replication in sql server.
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What is exporting utility?
How can you insert null values in a column while inserting the data?
What does set rowcount do?
Explain the xml support sql server extends?
How to convert numeric values to integers in ms sql server?
Explain about integration services of Microsoft SQL server?
Do you know spatial data types - geometry and geography in sql server 2008?
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 make a remote connection in a database?