Login
TKC Blog
25 Latest ArticlesCurrent Articles | Archives | Search

SQL Server

SQL Server related articles.

    13

    SQL Code to get data in pages for SQL Server 2005 plus

    tkaragiris posted on January 13, 2012 14:12
     Here is some SQL code for paging data from a large tables.  This code is handy for when you want to present data from a large table in a gr...

    [Read the rest of this article...]

    Posted in: SQL Server, IT Commentary
    Actions:E-mail | Permalink | Kick it! | DZone it! | del.icio.us
    13

    SQL Server search and replace text in table

    tkaragiris posted on January 13, 2011 16:18 Article Rating
    To do a search and replace in an SQL table use the following code: UPDATE <TABLE NAME> SET <COLUMN NAME> = CAST(REPLACE(CAST(<COLUMN ...

    [Read the rest of this article...]

    Posted in: SQL Server, IT Commentary
    Actions:E-mail | Permalink | Kick it! | DZone it! | del.icio.us
    15

    Stored Procedures or tables modified in the last x days

    tkaragiris posted on February 15, 2010 15:06 Article Rating
    The query below will find any stored procedures or tables modified within the last seven days: SELECT name AS [Stored Procedures]   ...

    [Read the rest of this article...]

    Posted in: SQL Server
    Actions:E-mail | Permalink | Kick it! | DZone it! | del.icio.us
    15

    Search stored procedure or view code for string

    tkaragiris posted on February 15, 2010 14:45 Article Rating
    You might find the following two SQL queries handy. They find a string within the SQL code of a stored procedure or view. -- Stored Procedure – looki...

    [Read the rest of this article...]

    Posted in: SQL Server
    Actions:E-mail | Permalink | Kick it! | DZone it! | del.icio.us
    Search Blog
    TKC Blog Latest Articles
    Blog Archive