Name few of the dcl commands in sql?
No Answer is Posted For this Question
Be the First to Post Answer
Explain what is the use of custom fields in report?
Which databases are part of SQL server default installation? Explain the usage of each?
What is difference between standardization and normalization?
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 do you set a trace flag in sql server?
what are the different types of replication you can set up in sql server? : Sql server database administration
What is the use of CASCADE CONSTRAINTS?
syntex of insert
Is t sql the same as sql server?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
How do you optimize Sql queries ?
What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning