There is no need to create the cursor to kill all the process on the sql server. Instead we call compose a string like this. declare @SQLString varchar(8000)
Read More
Try the following snippet. You can call the the below stored procedure from your application, so that NoOfUses in the coupon table will be updated.
Read More
Avoid using a SQL Server cursor for looping over records row by row. Alternate methods use temp tables instead of SQL cursors that slow down performance.
Read More
Learn how to use the DISTINCT keyword in SQL SELECT statements to eliminate duplicate rows. DISTINCT in SQL eliminates duplicate rows for your result set.
Read More
introduction to sql server management 2008 part 1 single_user, multi_user, off_line,on_line :
Ratings : 65 %
Different ways to replace NULL in sql server - Part 15 :
Ratings : 58 %
SQL Server Programming Part 6 - WHILE Loops :
Ratings : 11 %
SQL Server Programming Part 8 - Temporary Tables :
Ratings : 11 %
Define the Steps for SQL Server Cursor - SQL Server / TSQL Tutorial :
Ratings : 51 %
There is no need to create the cursor to kill all the process on the sql server. Instead we call compose a string like this. declare @SQLString varchar(8000)
Read More
Ratings : 15 %
Try the following snippet. You can call the the below stored procedure from your application, so that NoOfUses in the coupon table will be updated.
Read More
Ratings : 52 %
Avoid using a SQL Server cursor for looping over records row by row. Alternate methods use temp tables instead of SQL cursors that slow down performance.
Read More
Ratings : 69 %
SQL SERVER INTERVIEW QUESTIONS & ANSWERS | WHAT IS SQL PROFILER :
Ratings : 63 %
Learn how to use the DISTINCT keyword in SQL SELECT statements to eliminate duplicate rows. DISTINCT in SQL eliminates duplicate rows for your result set.
Read More
Ratings : 48 %
– simple use of cursor print all stored procedures on a sql server 2005. DECLARE @procName varchar(100) DECLARE @getprocName CURSOR SET …
Read More
Ratings : 66 %
Cursores en SQL Server :
Ratings : 66 %
Instead of delete triggers in sql server - Part 47.avi :
Ratings : 65 %
How to Remove Database Mirroring in SQL Server - SQL Server DBA Tutorial :
Ratings : 15 %
How to Stop and Start Database Mirroring Endpoints in SQL Server - MS SQL DBA Tutorial :
Ratings : 39 %