SQL Server Interview Questions
Questions Answers Views Company eMail

What do u mean by orphan users, how will u list them in the DB

IBM,

2 4400

What is the use of MOVE keyword in restore command

IBM,

3 3064

How will u find the query which is running in some other machine

IBM, CarrizalSoft Technologies,

4 3548




What is the role that is required for killing a process What is the role that is required for creating a linked server

IBM, CarrizalSoft Technologies,

1 2624

1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder

IBM, CarrizalSoft Technologies,

3 4809

There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"

2 1991

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 2086

How to get the count of distinct records. Please give me the query?

Value Labs,

8 7433




Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

Value Labs,

4 3890

Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.

247Customer,

3 3654

Hi SQL gurus, i am working for an MNC... My team is having a problem in sql server. when user slects date prompts from jan 1st to april 30, it should display all months data like : jan aa feb bb mar cc but when it comes to april its taking data like : jan aa feb bb mar cc apr dd...and so on means its taking data again from jan to april which we dont want. we want the data only april month as we are getting jan, feb and mar... can any one write the code to relsove the issue please would be greatful if you can send to shiva_sans@yahoo.co.in and also please send your email also ...so that we will be in touch for any kind of queries ... Thanks a lot in Advance !!!

1 2087

how to count datewise data in sqlserver

IndusInd Bank, CarrizalSoft Technologies,

4 10854

how we can count records as a group of days like sum of records for(four mondays),(four tuesday)........ in a month. group the column for weekdays.

1 2135

please tell me the query to get details of the employee having the second largest salary

247Customer,

11 6197

What is excution Plan in sql server

TCS, CarrizalSoft Technologies,

1 4340


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

whats the maximum size of view state??

948


after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

947


ow to bring suspect mode datbase online from scratch

684


how can u get last observation in an unknown dataset ?

1147


Scalability, Availability, Integration with internet, etc.)?

1648






what is checksum in sql server.........???

392


how many no of arguments can be passed in procedures and functions

3493


How to convert a table data in XML format in sql server?

1399


System variable and temporary variables

980


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.

705


Why we need to use secondry database file? though, we can do same work using primary database file also.

4215


how can you attach more than 20 ldf files in sql server

831


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

773


What is best institute to Learn DotNET And SQL in chennai?

969


how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

361