SQL Tips and Tricks Archives - Page 519 of 536 - SQL Authority with Pinal Dave

SQL SERVER – 2005 Explanation Left Semi Join Showplan Operator and Other Operator

May 23, 2007

I come across very interesting documentation about Joins, while I was researching about article about EXCEPT yesterday. There are few interesting kind of join operations exists when execution plan is displayed in text format. Left Semi Join Showplan Operator The Left Semi Join operator returns each row from the first…

SQLAuthority News – T-Shirts in Action

May 22, 2007

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL T-Shirt

Thank you All for great response to SQLAuthority T-Shirts. I have ran out of all of them. Please put your request here. I will go over all of them soon and see what I can do. They are made from high quality fiber and very comfortable. Reference : Pinal Dave…

SQL SERVER – 2005 Comparison EXCEPT operator vs. NOT IN

May 22, 2007

Pinal Dave

SQL Tips and Tricks

SQL Index, SQL Operator, SQL Scripts, SQL Server

The EXCEPT operator returns all of the distinct rows from the query to the left of the EXCEPT operator when there are no matching rows in the right query. The EXCEPT operator is equivalent of the Left Anti Semi Join. EXCEPT operator works the same way NOT IN. EXCEPTS returns any distinct values from the query to the left of the EXCEPT operand that do not also return from the right query.

SQL SERVER – Top 15 free SQL Injection Scanners – Link to Security Hacks

May 21, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Download, SQL Server Security

SQL injection is a technique for exploiting web applications that use client-supplied data in SQL queries, but without first stripping potentially harmful characters. Checking for SQL Injection vulnerabilities involves auditing your web applications and the best way to do it is by using automated SQL Injection Scanners. Security-Hacks.com compiled a…

SQL SERVER – 2005 Build List Link

May 21, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

What is Build List? All SQL Server has build list, this is incremental list of numbers which indicates which version SQL Server is running and what are its compatibility, patches etc. Regular Columnist Steve Jones of SQL Server Central has created build list. It is updated and informative. Microsoft Hot…

SQL SERVER – Script/Function to Find Last Day of Month

May 20, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts, SQL Utility

Following query will find the last day of the month. Query also take care of Leap Year. Script: DECLARE @date DATETIME SET @date='2008-02-03' SELECT DATEADD(dd, -DAY(DATEADD(m,1,@date)), DATEADD(m,1,@date)) AS LastDayOfMonth GO DECLARE @date DATETIME SET @date='2007-02-03' SELECT DATEADD(dd, -DAY(DATEADD(m,1,@date)), DATEADD(m,1,@date)) AS LastDayOfMonth GO ResultSet: LastDayOfMonth ----------------------- 2008-02-29 00:00:00.000 (1 row(s) affected)…

SQL SERVER – ASCII to Decimal and Decimal to ASCII Conversion

May 19, 2007

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server

In this blog post we will see how we can convert ASCII to Decimal and Decimal to ASCII. In simple words, we will see the decimal and ASCII conversion.