Dear Sir , your wrote: " I'd either use bcp to output to a temporary file and then concatenate the two together".

Please tell me that how would this be implemented.

...

Dear Joy Sir,

Thanks a lot for your reply, i also wanted to know that how do temporary tables hold the result set of a stored procedure. i have read about...

Dear Sir,

Thanks a lot for your reply, i also wanted to know that how do temporary tables hold the result set of a stored procedure. i have read about temporary...

Dear Jeff Sir,

Thanks a lot for your reply, i also wanted to know that how do temporary tables hold the result set of a stored procedure. i have read about...

Dear sir, then what are the main purposes for which temporary tables are used? Please tell, would be a great help. I want to know the practical and commercial...

thanks a lot sir, this solution is very very intellectual . thanks a lot. your are awesome

I CREATED A DATABASE--------

create database temporarytables

use temporarytables

--I CREATED TEMPORARY TABLE INSIDE A STORED PROCEDURE

create proc sp_testtemptable

as

begin

create table #temptable(tempno int)

end

THIS TIME I RUN THE SELECT * FROM #TEMPTABLE, OUTSIDE THE...

thanks a lot sir. your reply helped me a lot.

but for the delete case, what would you refer?

i want that when the user deletes the data from the table, then...

Dear Lowell Sir,

Actually, i have a .net application through which lacs of data would be inserted by the users.

but as usual, users keep on making mistakes. so i want that...

i have all admin privileges

YES, I GRANTED THE SELECT PERMISSION, BUT IT GIVES ERROR :

Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.

dear sir,

--FIRSTLY,i CREATE A LOGIN TO ENTER INTO SQL SERVER WITH SQL AUTHENTICATION

create login employeelogin with password='employee_login'

--CREATE A USER FOR THE ABOVE CREATED LOGIN

create user employeeloginuser for login employeelogin

--the...

dear greg sir,

--FIRSTLY,i CREATE A LOGIN TO ENTER INTO SQL SERVER WITH SQL AUTHENTICATION

create login employeelogin with password='employee_login'

--CREATE A USER FOR THE ABOVE CREATED LOGIN

create user employeeloginuser for login...

i entered sql server using admin credentials by default windows authentication.

now i create a login 'bob'.

what happens when i create a login in sql?

it becomes automatically the dbo i think?

means...

sorry, there's no drop, by mistake i typed it