SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

How to write an inner join with the where clause in ms sql server?

1079

What are the differences between user defined functions and stored procedures?

1060

What is index fragmentation in ms sql server?

1072

How to turn off warning messages during php execution?

1035

What are the differences between char and nchar in ms sql server?

1078

How to generate create function script on an existing function?

1108

What is a collation in ms sql server?

1073

What do you need to connect php to sql server?

1101

What is sql language?

1126

Can another user execute your local temporary stored procedures?

976

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

1005

How to enable tcp/ip protocol on a sql server?

1155

How to list all objects in a given schema?

1052

How to delete existing triggers using "drop trigger"?

1046

How to download microsoft sql server 2005 express edition?

1036

Un-Answered Questions { SQL Server }

What is difference between delete & truncate commands?

1072

Where the sql logs gets stored?

978

What is the user of Primary key?

973

What are the different sql server versions?

971

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

2012

Explain the usage of floor function in sql server.

956

How to edit table in sql server 2017?

921

Why use “nolock” in sql server?

1050

What is sql server profiler?

995

Explain full-text indexing?

971

What are different types of join?

1304

What is 'Join' and explain its various types.

1129

Can you please explain the difference between function and stored procedure?

1000

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

1012

Your table has a large character field there are queries that use this field in their search clause what should you do?

877

For More Un-Answered { SQL Server } Questions Click Here