Explain raiserror in sql server?
What are the different types of join?
your distribution database is full what will u do
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
where can you add custom error messages to sql server? : Sql server administration
What do you think of this implementation? Can this be implemented better?
What is a print index?
How will you go about resolving deadlocks?
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 is the default server name for sql server?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
What is the STUFF function and how does it differ from the REPLACE function?
What is indexed view? How to create it?