• Undocumented stored procedure: Return string type for a column with sp_gettypestring

    One useful (albeit unsupported) stored procedure in SQL Server 2000 is the sp_gettypestring, which can be used to return the type string for a column in a table.

    SearchWindowsServer1,010 pointsBadges:
  • Undocumented stored procedures: Registry manipulation in SQL Server 7.0 and 2000

    Among the many undocumented functions you'll find in SQL Server 7.0 and 2000 is a set of extended stored procedures to obtain, set and delete Registry keys. Contributor Serdar Yegulalp explains when and how to use these procedures.

    SearchWindowsServer1,010 pointsBadges:
  • Q&A: Writing stored procedures in SQL Server 2005

    When writing stored procedures in SQL Server 2005, you have options beyond T-SQL. Contributor Serdar Yegulalp explains the benefits of writing stored procedures using CLR and how to convert existing stored procedures to the CLR model.

    SearchWindowsServer1,010 pointsBadges:
  • Optimizing transactions through stored procedures

    Some things to ponder when you are optimizing transactions through stored procedures.

    SearchWindowsServer1,010 pointsBadges:
  • Undocumented SQL Server stored procedures

    T-SQL commands should not be used to manipulate the file system for security reasons, but some undocumented SQL Server stored procedures can help you work with directories, files and drives.

    SearchWindowsServer1,010 pointsBadges:
  • Saying yes, no or maybe to stored procedures

    The world of software somewhat resembles a pendulum. Styles of development swing in and out of favor. Take stored procedures, which work to some extent and may sometimes be the shortest way to a successful project.

    Jack Vaughan2,370 pointsBadges:
  • Saying yes, no or maybe to stored procedures

    The world of software somewhat resembles a pendulum. Styles of development swing in and out of favor. Take stored procedures, which work to some extent and may sometimes be the shortest way to a successful project.

    Jack Vaughan2,370 pointsBadges:
  • Stored procedures: Create and manage standard objects

    This set of tools will quickly generate the necessary T-SQL code to create the objects needed for a proposed surrogate key architecture.

    ITKE54,745 pointsBadges:
  • How to use SQL Server 2008 hierarchyid data type

    SQL Server 2008 offers the new hierarchyid data type – an improved method for storing and querying data. Stored procedures can dynamically find their way up the employees' management tree but they make for complex, resource-intensive queries. With the hierarchyid data type in SQL Server 2008, a...

    Denny Cherry65,450 pointsBadges:
  • Stored procedures: Find columns and tables

    Continuing our stored procedure series, this simple routine is handy for finding columns by name and listing the table(s) in which they exist. The listing includes table name, column name, ordinal position, data type, data size, width/precision and scale.

    ITKE54,745 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following