create log tables and trigger modyfied

i was trying to use the script 'create log tables and trigger' by well0549 it was very helpfull but at some tables it just didnt work ..later i find out that these tables have an identity columns but they were tinyint or small int .. i didnt do much but i did add less than […]

If you execute this in SQL Server 2005's...

How to Insert Values into an Identity Column in SQL Server

Identity columns are commonly used as primary keys in database tables. These columns automatically assign a value for each new row inserted. But what if you want to insert your own value into the column? It's actually very easy to do.

What are the two uses of % in T-SQL

SSRS Multi-Select

Regarding:Multi-Select Parameters for Reporting ServicesRegular Columnist : Adriaan Davel Posted: 08/13/2007  Our solution:Create a table function to parse the values into a table.Usage:In a stored procedure called by SSRS, pass the multi-select values into this function to return a table of key/value pairs.ie:select * from fnCSV_Parse (',' , 'ca,de,ny,wa')yeilds:tblID       Keys-----------------1        […]

T-SQL error handling with Try…Catch blocks

T-SQL Try…Catch block for SQL Server exception handling has new, improved functions to handle errors when executing T-SQL code in SQL Server 2005.

10 tips for sorting, grouping, and summarizing SQL data

Arranging SQL data that you can effectively analyse requires an understanding of how to use certain SQL clauses and operators. These tips will help you figure out how to build statements that will give you the results you want.

On your brand new SQL Server 2005 instance,...

Using BCP to export the contents of MAX datatypes to a file

Phil Factor presents a poetic stored procedure for storing any VARCHAR(MAX) to file.

You are having issues with queries running strangely...