T-SQL

Granting Access Permissions...

  • Script

Usually when we recreate or rename a table we need to give the appropriate access permissions to the SQL users...this is very common in database under development environment where frequently table structure changes and we have to recreate it....we can accomplish this with Enterprise Manager but what will you do if Enterprise Manager fails to […]

2001-12-18

801 reads

List all primary keys

  • Script

Thanks to Raul Sharma for his brilliant ideas. This is a modification of one of his scripts. The script takes only the user tables. Those tables which does not have PK are not listed!

4 (1)

2001-12-13

717 reads

Pass an Array into a Stored Procedure

  • Script

Have you ever wished T-SQL allowed you to pass an array into a stored procedure? Well the spListToTable stored procedure listed below accepts a delimeted string and turns it into a table. Code your stored procedure to accept a varchar, create a temporary table, call spListToTable, and use the populated temporary table as if it […]

4.25 (4)

2001-12-10

2,823 reads

HOWTO: Run Singleton SELECT Queries in a Visual Basic Client

  • Article

This article demonstrates how to retrieve a single record from SQL Server by using the IRow interface with a singleton SELECT. The main purpose for this technique is to avoid the overhead of creating a recordset when you are fetching a single record. Because no recordset is actually created, only one read-only ADODB.Record is returned. This is true even if the specified SELECT results in multiple records being returned if a normal ADODB.Recordset is used.

2001-11-26

1,684 reads

Loop through records without using a cursor

  • Script

I sometimes have to loop through records in a database and perform a specific action on the value that is returned. For example, In the script below I loop through the user tables in sysobjects and simply print them out. This technique is useful when dropping all indices/triggers on a particular table, or adding WITH […]

3 (2)

2001-11-25

9,132 reads

Update Foreign Key References

  • Script

This script updates all foreign key references for the specified table. Useful if you need to delete a row. The follow example would update all uses of TableA.IDENTITYCOL where the value is 1 to the value of 2. Example usage: EXEC usp_updateFK 'TableA', 1, 2

2001-11-03

1,434 reads

Blogs

Reflection on Talking at SQLSaturday Charlotte About Mental Health

By

On December 7, I did a session on mental illness and mental health problems...

A guide to acronyms, abbreviations, and other technical terms

By

Here’s a list of some technical terms, acronyms, and abbreviations you may have heard,...

T-SQL Tuesday #121: Gifts received for this year

By

At the end of 2019, Mala (b|t) invites us to write about the gifts we’ve...

Read the latest Blogs

Forums

Read only node consistency

By tcroninlifepoint

I realize this is a reach, users stating that some of their data is...

Script Task - use DataTable for performance improvements?

By DinoRS

Hi SSC, I have this Script Task which will make quite a few reebars...

Probably Invalid Parameters Email Failure

By clarmatt73

We have a job which runs throughout the day which sends emails out if...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers