SQL Scripts Archives - Page 298 of 318 - SQL Authority with Pinal Dave

SQL SERVER – 2008 – Scheduled Launch at an Event in Los Angeles on Feb. 27, 2008

July 11, 2007

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

SQL SERVER 2008 will be launched at an Event in Los Angeles on Feb. 27, 2008. “In anticipation for the most significant Microsoft enterprise event in the next year, Turner announced that Windows Server® 2008, Visual Studio® 2008 and Microsoft SQL Server™ 2008 will launch together at an event in…

SQL SERVER – Count Duplicate Records – Rows

July 11, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Duplicate Records, SQL Scripts

In my previous article SQL SERVER – Delete Duplicate Records – Rows, we have seen how we can delete all the duplicate records in one simple query. In this article we will see how to find count of all the duplicate records in the table. Following query demonstrates usage of…

SQL SERVER – 2005 – List All Stored Procedure Modified in Last N Days

July 10, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Scripts, SQL Stored Procedure

I usually run following script to check if any stored procedure was deployed on live server without proper authorization in last 7 days. If SQL Server suddenly start behaving in un-expectable behavior and if stored procedure were changed recently, following script can be used to check recently modified stored procedure.…

SQL SERVER – Result of EXP (Exponential) to the POWER of PI – Functions Explained

July 9, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

SQL Server can do some intense Mathematical calculations. Following are three very basic and very necessary functions. All the three function does not need explanation. I will not introduce their definition but will demonstrate the usage of function. SELECT PI() GO SELECT POWER(2,5) GO SELECT POWER(8,-2) GO SELECT EXP(99) GO…

SQL SERVER – FIX : ERROR Msg 244, Level 16, State 1 – FIX : ERROR Msg 245, Level 16, State 1

July 8, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Function, SQL Scripts

FIX : ERROR Msg 244, Level 16, State 1, Line 1 FIX : ERROR Msg 245, Level 16, State 1, Line 1 This error can happen due to conversion of one data type to incompatible datatype. Few examples are: VARCHAR to INT, INT to TINYINT etc. I have spotted this…

SQL SERVER – Convert Text to Numbers (Integer) – CAST and CONVERT

July 7, 2007

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Best Practices, SQL Function, SQL Scripts

Few of the questions I receive very frequently. I have collect them in spreadsheet and try to answer them frequently. How to convert text to integer in SQL? If table column is VARCHAR and has all the numeric values in it, it can be retrieved as Integer using CAST or…

SQL SERVER – 2005 – Microsoft Document Explorer cannot be shown because the specified help collection ‘ms-help://MS.SQLCC.v9

July 5, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download, SQL Error Messages, SQL Scripts, SQL Utility

I have received six emails in last four days asking for the resolution of error when tried to open newly installed SQL Server Book On-Line. Microsoft Document Explorer cannot be shown because the specified help collection ‘ms-help://MS.SQLCC.v9 1) Uninstall the versions of Book On-line (different languages, different releases etc) using…