Explain what is cte (common table expression)?


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

Post New Answer

More SQL Server Interview Questions

How to search for a string in all stored procedure in sql server?

0 Answers  


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

2 Answers  


what is the output for this query select * from employee where 1=1;

4 Answers  


What is a coalesce function?

0 Answers  


After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )

3 Answers   CarrizalSoft Technologies, iGate,






How many nested transaction can possible in sql server?

3 Answers   Bank Of America,


What is msdb database? : SQL Server Architecture

0 Answers  


What is The Use Of TIMESTAMP DataType in SQL Server 2005?

6 Answers  


How to optimize stored procedure optimization?

0 Answers  


How many types of system privileges are there, Can we add or delete privileges?

2 Answers  


Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers  


How many triggers you can have on a table?

0 Answers  


Categories