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 insert and update data into a table with "insert" and "update" statements?

987

How to change the data type of an existing column with "alter table" statements in ms sql server?

983

What happens when converting big values to numeric data types?

1136

Can we delete data from a view?

925

How to update multiple rows with one update statement in ms sql server?

1205

What happens if an integer is too big for int date type?

978

Can binary strings be used in arithmetical operations?

937

What is a transact-sql statement?

1064

How to create stored procedures with parameters in ms sql server?

1079

How to specify the collation for a character data type in ms sql server?

1030

Does index slows down insert statements?

1002

What are the basic features of a trigger in ms sql server?

1193

Where is my database stored on the hard disk in ms sql server?

1061

What is a database in ms sql server?

1058

What are commonly used mssql functions in php?

1081

Un-Answered Questions { SQL Server }

What does it mean to invest in the index?

973

How much is a sql server license?

955

What is the cpu pressure?

1042

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

1051

Can we join two tables without primary key?

1054

What are transactions in sql?

1062

What is the default schema of your login session in ms sql server?

1049

Explain few examples of stored procedure over triggers?

1044

What is an inner join?

983

Explain syntax for viewing, dropping and disabling triggers?

953

Explain full-text query in sql server?

1009

How to delete a login name in ms sql server?

1076

What is difference between views and tables?

1011

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

881

Explain left outer join and right outer join?

1040

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