SQL Function Archives - Page 46 of 52 - SQL Authority with Pinal Dave

SQL SERVER – CASE Statement in ORDER BY Clause – ORDER BY using Variable

July 17, 2007

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

This article is as per request from Application Development Team Leader of my company. His team encountered code where application was preparing string for ORDER BY clause of SELECT statement. Application was passing this string as variable to Stored Procedure (SP) and SP was using EXEC to execute the SQL…

SQL SERVER – Validate Field For DATE datatype using function ISDATE()

July 12, 2007

Pinal Dave

SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts, SQL Server

This article is based on the a question from Jr. Developer at my company. He works with the system, where we import CSV file in our database. One of the fields in the database is DATETIME field. Due to architecture requirement, we insert all the CSV fields in the temp table which has all the fields VARCHAR. We validate all the data first in temp table (check for inconsistency, malicious code, incorrect data type) and if passed validation we insert them in the final table in the database. Let us learn about ISDate function in this blog post.

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 – Explanation of WITH ENCRYPTION clause for Stored Procedure and User Defined Functions

July 1, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Server Encryption, SQL Stored Procedure

This article is written to answer following two questions I have received in last one week. Questions 1) How to hide code of my Stored Procedure that no one can see it? 2) Our DBA has left the job and one of the function which retrieves important information is encrypted,…

SQL SERVER – Repeate String N Times Using String Function REPLICATE

June 25, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL String

I came across this SQL String Function few days ago while searching for Database Replication. This is T-SQL Function and it repeats the string/character expression N number of times specified in the function. SELECT REPLICATE( ' https://blog.sqlauthority.com/ ' , 9 ) This repeats the string https://blog.sqlauthority.com/ to 9 times in…