What is #temp and @table variable in SQL server?

Question Posted / savitri

No Answer is Posted For this Question
Be the First to Post Answer

More SQL Server Interview Questions

Explain the difference between clustered and non-clustered index?

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

What do you understand by integration services in sql server?

how can i view structure of table in sql server? tell me that query.

How to assign null values to variables or columns?

Explain the steps to create and execute a user-defined function in the sql server?

What is the default sql server instance name?

Will the writetext statement activate a trigger?

How to create and drop temp table in sql server?

How to use “drop” keyword in sql server and give an example?

How to create function without parameter in sql server?

List out different types of normalizations in sql server and explain each of them?

For more SQL Server Interview Questions Click Here