Insert into statement in sql server

http://www.codeproject.com/KB/database/InsertGeneratorPack.aspx

Read More

How to restore database when database was suspect

EXEC sp_resetstatus DataBaseName;
ALTER DATABASE DataBaseName SET EMERGENCY
DBCC checkdb(DataBaseName)
ALTER DATABASE DataBaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB (DataBaseName, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE DataBaseName SET MULTI_USER

Read More

Declare Nested Cursor in Sql Server

declare @id bigint
--Declare outer cursor

declare outer_cursor cursor for

select id from table

--Declare inner cursor as a variable

declare @inner_cursor cursor

open outer_cursor

fetch next from outer_cursor into @id

while(@@FETCH_STATUS=0)

begin

-- Few statements

declare @cartid bigint

declare @qty bigint

set @inner_cursor = cursor for select id,qty from cart where productid=@id

open @new_count
fetch next from @inner_cursor into @cartid, @qty while(@@FETCH_STATUS=0)

begin

--Few Statements

end

end

Read More