SQL Server Interview Questions
Questions Answers Views Company eMail

What is Check point? Explain in Brief what it will do?

Wipro,

1 3782

What is DAC? what is the use of it?

Wipro,

1 4026

what is Buffer cash and Log Cache? Can you Explain it?

Wipro,

1 5935




hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution

2 2278

does physical index sort data

1 2042

what type of indexes physically sort data?

3 4244

what is differencial backup?how to work?Anybody explai it?

HCL,

2 2698

what is sql injection in sql server?

TATA,

2 3556




what is node in sql server?

Google, NIIT, TATA, CarrizalSoft Technologies, Nittany,

2 20024

How to store pdf file in sql server?

TATA, CarrizalSoft Technologies, College School Exams Tests,

1 4584

What is difference between stored procedure & function?

TATA, CarrizalSoft Technologies, Concept Infoway,

3 4317

How to Rebuild Master database in sql server 2005.

Wipro,

2 3189

please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on

1 1670

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 2266

what is trigger . hw will it use them

TCS,

2 3551


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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

912


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

2628


Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

669


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

1046


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

998






What is Lock table in SQL?

199


In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

828


on line cluster can we make if yes tell me the procedure

793


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

318


how to use DTS package in 2000,2005,2008 in sql server

734


what is difference between view and Dip.

1137


Working with TLogs

640


1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

737


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

264


How can we call UDF(User Define Function) using C# code in ASP.net ?

4581