What are functions3 6024
how to get the automatic backup of the database in the sql server4 31410
What command do we use to rename a db?5 8101
Which command using Query Analyzer will give you the version of SQL server and operating system?3 11940
What is the STUFF function and how does it differ from the REPLACE function?2 16728
What is the purpose of UPDATE STATISTICS?2 9618
What is de-normalization and when do you do it?3 5250
Explain some DBCC commands?6 13615
What is the purpose of using COLLATE in a query?1 15937
You are doing log shipping due to some reasons it is failing. How you will proceed from there
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
What is RMS migrations?
whats the maximum size of view state??
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What is the difference between NOROW and LOCKROW?
If user is owning any SQL Objects, can we drop that user
how to take backup bcp out for a column in table in sql server?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
how can u get last observation in an unknown dataset ?
whats new about truncate in sql server 2008?
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
System variable and temporary variables
how many no of arguments can be passed in procedures and functions
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.