|
|
-
Sergejack Commented 12 Months ago through Interview Questions | 1 Point
You are right, Manjunath C Bhat.
IT's a surprise, I really though you could create temp table in sp and reuse them latter. But I guess it just goes for global temp tables....
|
-
Sergejack liked 12 Months ago through Interview Questions | 1 Point
I have a stored procedure like below and have created a temporary table inside it and have not written any drop statement for this Temporary Table.
Now when i execute this procedure for first time it will create the temporary table. Now when i run this ...
|
-
Sergejack Commented 12 Months ago through Interview Questions | 1 Point
Are you sure the sp creates/loses its own session? If the sp is called twice in the same transaction, won't there be an error?...
|
-
Sergejack Commented 1 Years ago through Interview Questions | 1 Point
I think this was recently discussed here.
Not sure it was posted in the "Interview" section though....
|
|
|
-
Sergejack liked 1 Years ago through Interview Questions | 1 Point
In ASP.NET Page life cycle, where Page_PreInit and Page_Prerender events can be useful?...
|
-
Sergejack Commented 1 Years ago through Interview Questions | 1 Point
Saddly it happens during the PreInit stage which complicates how you can set them dynamically.
I guess that pattern was chosen with some optimisations' objectives....
|
|
|
-
Sergejack liked 1 Years ago through Interview Questions | 1 Point
Some class has a field declared as readonly array, for example:
private readonly int[] _array = new int[10];
Is it allowed to change elements of this array ?...
|
-
Sergejack Commented 1 Years ago through Interview Questions | 1 Point
I'm not sure I remember which one is which, but I think it's more about webcontrol that are or not a compositions of one or several others....
|