What happens if null values are involved in arithmetic operations?
What is candidate key with example?
How do I setup a sql server database?
what is an extended stored procedure? : Sql server database administration
What are the system database in sql server 2008?
How to delete database objects with "drop" statements in ms sql server?
What does sql server mean?
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
Explain datetime2 data type in sal server 2008?
What is store procedure? How do they work? When do you use?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
What is unpivot?
What are audit control procedures?
Can we write ddl in trigger?
What is the purpose of sql profiler in sql server? : sql server database administration