Tag Archives: T-SQL

Sending multiple values in the form of array to a SQL Server stored procedure is very common among database developers.  We can send the values in either of the two methods as following:   ·          Comma separated values (in a … Continue reading →

Hello,   This is third in series focusing on the following topics:   A bit more concentration on CASE CASE with IF Utilizing @@ROWCOUNT Working with TABLES (Table Variables) in T-SQL The article is available at http://www.aspfree.com/c/a/MS-SQL-Server/Using-ROWCOUNT-and-TABLE-Variables-for-Database-Interactions-with-TransactSQL/ thanks Jag

Hai,   You can find part 2 of the series focusing on "database interactions with Transact-SQL" here at http://www.aspfree.com/c/a/MS-SQL-Server/How-to-Use-Variables-IF-and-CASE-in-Database-Interactions-with-TransactSQL/   Enjoy, Jag

Hai,   Started a new tutorial series to completely cover Transact-SQL Programming (right from its basics).  The first is here:   http://www.aspfree.com/c/a/MS-SQL-Server/Working-wth-Variables-in-Database-Interactions-with-Transact-SQL/   enjoy and let me know if you want any topic..   thanks Jag

Hello,   My latest article on working with T-SQL stored procedures to deal with lookup tables is published at http://www.aspfree.com/c/a/ASP.NET/Developing-TSQL-Stored-Procedures-to-Deal-with-Lookup-Tables/   Enjoy.  Any feedback or discussion on that is very much appreciated.. bye Jag

Hai,   I contributed new article on dealing with .NET CLR Programming using SQL Server 2005.  I made it very simple to understand the core features of it.  You can access it at http://www.aspfree.com/c/a/MS-SQL-Server/NET-CLR-Programming-with-SQL-Server-2005-Made-Simple/   Feel free to comment on … Continue reading →