Search results for query: *

Nikhil, Your proc is behaving exactly same what my proc does. Another solution I found that to use dynamic SQL. Thanks for your kind help. Praveen

The funny part is after executing first part (with parameter 1), Table is got created, but still second part (with parameter 2) does not able to find it.

Hi, Can somebody tell me why following is happening? When I am executing following proc with paramter 1, it is runnig fine. But when I am giving parameter 2, it is giving me following error message: Table 'cas_t' can not found. Stored Procedure create proc sp2 (@proc int) as begin if @proc...

Hi, Who is agree with me that select is not a DML, and why? My thinking is, as Select is not modifying data in table, and DML denotes set of statements, which can modify data in table. Thanks. Pravin

Hi all, Can somebody help me about what is hot & cold backup? Or where can I get information about this in detail. thanks in advance band

Hi, I am giving the way by which you can do it. 1. Count Number of rows that will affect by your query and store it in a local variable. 2. Write a cursor with your SQL 3. In body of cursor take first 5 rows based on the counter. 4. Keep on accessing the data and enable to take data flag...