Tag: SQL Server

The real difference between SQL Server and Oracle

Visit : https://zonixsoft.com (our Official website) For years now there’s been a constant war between Microsoft supporters and Oracle supporters. Oracle has these features, SQL Server has these features, etc. But that’s not really where the real importance lies. Sure, functionality is a part of it because your database should be able to do what […]

UPDATE Based Off of A Table

visit : https://zonixsoft.com (our official website)  INSERT offers the ability to insert into a table based upon a SELECT statement with the following syntax: INSERT INTO [TABLEA] ([FIELDA],[FIELDB],[FIELDC])         SELECT [FIELDA],[FIELDB],[FIELDC] FROM [TABLEB]   there are time where you may want to do a similar approach with UPDATE. Here is the syntax to do that […]

Passing parameters to dynamic query

visit https://zonixsoft.com (our official Website)   Consider following queries 1. SELECT * FROM @tablename 2. SELECT @colname FROM tbl 3. SELECT * FROM tbl WHERE x IN (@list) 4. SELECT @Cnt=Count(*) FROM tbl WHERE x IN (@list)   For the first query, it will give error ‘Must declare the table variable “@tablename”‘ if @tablename is […]

MERGE Command in SQL Server

visit: https://zonixsoft.com (our official website) In SQL Server 2008, Microsoft introduces the MERGE functionality through the MERGE command. The MERGE command inserts rows that don’t exist and updates the rows that do exist.     What MERGE Command works as,         IF FOUND            THEN UPDATE         ELSE            INSERT;     Until now, this MERGE functionality could […]

CASE (Transact SQL)

Evaluates a list of conditions and returns one of multiple possible result expressions. CASE has two formats: · The simple CASE function compares an expression to a set of simple expressions to determine the result. · The searched CASE function evaluates a set of Boolean expressions to determine the result. Examples: A. Using a SELECT […]

CASE (Transact SQL)

Evaluates a list of conditions and returns one of multiple possible result expressions. CASE has two formats: · The simple CASE function compares an expression to a set of simple expressions to determine the result. · The searched CASE function evaluates a set of Boolean expressions to determine the result. Examples: A. Using a SELECT […]

Paging in SQL Server

Visit: https://zonixsoft.com (our official Website) Web Application Performance (Paging in Sql Server) As a Web developer, you know by now that using the default paging capabilities of ASP.NET Webcontrols like DataGrid and GridView cause the Performance issue when we have thousands and thousands of records in our database; because with every roundtrip to the data-server, […]

Paging in SQL Server

Visit: https://zonixsoft.com (our official Website) Web Application Performance (Paging in Sql Server) As a Web developer, you know by now that using the default paging capabilities of ASP.NET Webcontrols like DataGrid and GridView cause the Performance issue when we have thousands and thousands of records in our database; because with every roundtrip to the data-server, […]

Passing lists to SQL server stored procedures

Visit : https://zonixsoft.com (our official wbsite) Article is about: The ability to pass “a list of values” from .Net as a parameter to a T-SQL based stored procedure. Scenarios: There are lots of scenarios where we need to pass a list of values to save in database. Here’s a couple of obvious ones: · INSERT […]

Passing lists to SQL server stored procedures

Visit : https://zonixsoft.com (our official wbsite) Article is about: The ability to pass “a list of values” from .Net as a parameter to a T-SQL based stored procedure. Scenarios: There are lots of scenarios where we need to pass a list of values to save in database. Here’s a couple of obvious ones: · INSERT […]