T-SQL scripting 
Author Message
 T-SQL scripting

Hi, can anyone tell me where I can find a good resource on SQL scripts for
beginners.  If possible, can anyone send me an example of one?  I need to
develop a script that will check for the existence of users in a certain
database, and delete those users that are in the cancelled id list.  If
anyone can give me insights on where should I start, your assistance is
greatly appreciated.

Thank you,

James



Sun, 20 Apr 2003 02:22:18 GMT
 T-SQL scripting


Quote:

> Hi, can anyone tell me where I can find a good resource on SQL
scripts for
> beginners.  If possible, can anyone send me an example of one?  I
need to
> develop a script that will check for the existence of users in a
certain
> database, and delete those users that are in the cancelled id list.
If
> anyone can give me insights on where should I start, your assistance
is
> greatly appreciated.

Ed Barlow has a lot of stuff in his site:
http://www.edbarlow.com

Regards,
Mariano Corral

Sent via Deja.com http://www.deja.com/
Before you buy.



Sun, 20 Apr 2003 03:27:48 GMT
 T-SQL scripting
In article <Pine.GSO.4.21.0010311018180.10023-


Quote:

> Hi, can anyone tell me where I can find a good resource on SQL
scripts for
> beginners.  If possible, can anyone send me an example of one?  I
need to
> develop a script that will check for the existence of users in a
certain
> database, and delete those users that are in the cancelled id list.

create a table (cancelids)of cancelled ids in this form in an admin or
centralized database

idx(smallint)     canid(char(30))
------------      ---------------
1                 mleonard
2                 ksmith
3                 mchammer
4                 jlopez

then run the following code

use <database>
go




begin


  begin

  end

end
go

--  Kermit Lowry, III
----------------
"Only you can prevent forest fires!" -Smoky
at kp.org use kermit.lowry

This input does not necessarily reflect the opinion of my employer.

Sent via Deja.com http://www.deja.com/
Before you buy.



Sun, 20 Apr 2003 03:27:02 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. How can I script db from tsql script?

2. Running TSQL scripts in MSDE

3. TSQL Scripting of Create Table

4. Batch TSQL Script with SQLDMO

5. tsql scripts

6. Long TSQL Script

7. Job with TSQL script does not work

8. Resuming after error in TSQL script

9. Job with TSQL script does nrt work

10. TSQL Script to generate SQL scripts of data in a table?

11. Is there any way to exit a TSQL script completely?

12. How-To pass variable to TSQL Script with "Create Database"


 
Powered by phpBB® Forum Software