SQL Server Interview Questions
Questions Answers Views Company eMail

How can I know what query is executing by by a particural user? (using sp id or any othe way.)

2 2759

what is the main difference between after trigger and instead trigger.

2 16831

I have to display ten columns values from diffrent ten tables. how many joins are require?

HCL, CarrizalSoft Technologies,

10 8205




What is Report Server,Report Manager and Report Builder in SSRS 2005?

1 15631

What is Peer to peer Replication?

HCL, CarrizalSoft Technologies,

1 4047

what is a cursor and what is its use?

L&T,

2 5370

what is syntex second or third highest salary. thanks & Regards Dhirendra sinha

7 4651

what is trigger

NIIT, CarrizalSoft Technologies,

1 2755




what is difference between nchar and char in Sql server ?

3 5105

How can we write or define DDL statements in Sql server and DML statements?

3 3568

i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L

8 3010

write down the code for "how we delete a table without using of Drop command " ?

Sonata, CarrizalSoft Technologies,

7 5687

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 2215

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h

1 2093

Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)

8 7577


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

what are the critical issues you have resloved in your company

789


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

813


hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

1572


what are the Prerequisites for Replication?

8340


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

1607






sql database suspect We have a sql database that is showing as suspect. How can we recover?

686


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?)

682


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

898


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

848


What is data modeling and Reterminal integrity?

632


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

831


What is the difference between online clustering and Offline clustering?

1197


how to overcome kernel isssues

445


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

936


how to take backup bcp out for a column in table in sql server?

820