Define Unique Key?
What method is used by the Command classes to execute SQL statements that return single values?
Difference between 2NF &3NF ?
What does dml stand for?
How to update multiple rows with one update statement in ms sql server?
syntex of insert
What is the order in which the SQL query is executed? list them in order.
5 Answers CarrizalSoft Technologies, CTS, Oracle,
How can u convert the Date to String?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
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
What are the different types of stored procedures?
What command is used to create a database in the sql server and how?
Why do we partition data?