Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Content with tag
cursor
Items 1 to 4 of 4
Check Candidate Columns for NOT NULL Constraints
This script reports table columns that allow NULL values but that currently have no NULL values, making them candidates for adding a NOT NULL constraint.
Read more...
By
Charles Jacobus
2013/01/23
|
Source:
SQLServerCentral.com
|
Category:
data integrity
Rating:
|
Discuss
|
Briefcase
|
562 reads
A simple T-SQL statement to create a list of lookup values
In this article, we provide a simple way to get a comma delimited list from a table of entries without having to use a CURSOR or a WHILE loop to read through the table.
Read more...
By
Suresh G. Kumar
2012/09/28 (first published: 2011/03/21)
|
Source:
SQLServerCentral.com
|
Category:
cursor
Rating:
|
Discuss
|
Briefcase
|
32,893 reads
A simple T-SQL statement to create a list of lookup values
In this article, we provide a simple way to get a comma delimited list from a table of entries without having to use a CURSOR or a WHILE loop to read through the table.
Read more...
By
Suresh G. Kumar
2012/09/28 (first published: 2011/03/21)
|
Source:
SQLServerCentral.com
|
Category:
cursor
Rating:
|
Discuss
|
Briefcase
|
32,893 reads
4 Ways to Increase Your Salary (Using UPDATE)
This article depicts how to approach row by row updates needed in a salary table. It might not directly let you increase your salary, but it could help you at review time.
Read more...
By
Arup Chakraborty
2009/11/26
|
Source:
SQLServerCentral.com
|
Category:
cursor
Rating:
|
Discuss
|
Briefcase
|
7,888 reads
Items 1 to 4 of 4
Tags
alternative to cursors
(1)
data integrity
(1)
dynamic sql
(1)
maintenance
(1)
system view
(1)
table variables
(1)
t-sql
(1)
while loop
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.