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

Just a day ago, we faced situation where one column in database contained two values which were separated by comma. We wanted to separate this two values in their own columns. It was interesting that value of the column was variable and something dynamic needed to be written. Following is…

SQL SERVER – SQL SERVER – UDF – Get the Day of the Week Function – Part 2

May 23, 2008

SQL DateTime, SQL Function, SQL Scripts

I have written article about SQL SERVER – UDF – Get the Day of the Week Function. I have received good modified script from reader Mihir Popat has suggested another code where Sunday does not have to be necessary the first day of the week. CREATE FUNCTION dbo.udf_DayOfWeek(@dtDate DATETIME) RETURNS…

SQL SERVER – Function Property – Deterministic or Non-Deterministic

May 10, 2008

I recently received question through email that how to determine if any user defined function is deterministic or non-deterministic? First go through two articles I have written about deterministic and non-deterministic function. SQL SERVER – Deterministic Functions and Nondeterministic Functions SQL SERVER – 2005 – Use of Non-deterministic Function in…

SQL SERVER – 2005 – Restore Database Using Corrupt Datafiles (.mdf and .ldf) – Part 2

April 10, 2008

SQL Backup and Restore, SQL Data Storage, SQL Function, SQL Scripts

Blog reader Donald Crowther has posted following comment. I have not tested this solution and when I tried to test it, it did not work for me. However, I have received email from two of my Jr. DBA who have done experiment about this and they are suggesting it works.…

SQL SERVER – 2005 – Transferring Ownership of a Schema to a User

April 5, 2008

One of the blog reader asked me how transfer of ownership of schema to another users. Follow the simple script and you will be able to transfer ownership of schema to another user. ALTER AUTHORIZATION ON SCHEMA::SchemaName TO UserName; GO Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – Find Nth Highest Salary of Employee – Query to Retrieve the Nth Maximum value

April 2, 2008