Explain what is use of dbcc commands?
ow to bring suspect mode datbase online from scratch
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
What are the properties of sub-query?
How to join two tables in a single query in ms sql server?
What is amo? : sql server analysis services, ssas
I have a table Events Events containing cardno,time,id,name- -each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
How to use wildcard characters in like operations in ms sql server?
What is resource db in sql server?
What are triggers? How do you invoke a trigger on demand?
what do you understand by change data capture?
how to insert the values in 5 table at a time with triggers . if u have any solution then co-operate me ?