Tables in SQL Server

When writing T-SQL code, you often need a table in which to store data temporarily when it comes time to execute that code. You have four table options: normal tables, local temporary tables, global temporary tables and table variables. I’ll discuss the differences between using temporary tables in SQL Server versus table variables. Each of the four table options has its own purpose and use, and each...

Alternatives to @@IDENTITY

Normal 0 false false false EN-US X-NONE X-NONE ...

Two Interceptors: HttpModule and HttpHandlers-downloading a file

Introduction Many times we want to implement pre-processing logic before a request hits the IIS resources. For instance you would like to apply security mechanism, URL rewriting, filter something in the request, etc. ASP.NET has provided two types of interception HttpModule and HttpHandler. This...

50 Common Interview Questions and Answers :

Review these typical interview questions and think about how you would answer them. Read the questions listed; you will also find some strategy suggestions with it.1. Tell me about yourself:The most often asked question in interviews. You need to have a short statement prepared in your mind. Be careful that it does not sound rehearsed. Limit it to work-related items unless instructed otherwise....

cursors status

1 Find out the cursors that are allocated but not opened or closed view sourceprint?01.--Method 1 02. 03.select name from sys.dm_exec_cursors(0) where is_open =004. 05. 06.--Method 207. 08.select09. cur.cursor_name 10.from11. sys.syscursorrefs as ref inner join sys.syscursors as cur on ref.cursor_handl=cur.cursor_handle12.where13. cur.open_status =0 2 Find out the cursors that...