Sql Server Function Returns date in YYYYMMDD Format smsaxena.blogspot.in 16 Aug 2012 | 09:00 pm

Create FUNCTION [dbo].[fn_YMDDate] ( @dateParam     varchar(10) ) RETURNS Varchar(10) AS BEGIN DECLARE @Return Varchar(10) Declare @YYYY  varchar(4) Declare @MM  varchar(2) Declare @DD  varchar(2) De...

MS SQL server Function to read response from Http mkmpvtltd.eu.pn 3 Feb 2013 | 10:40 am

DTS not support in SQL Server 2008 R2 sqltutorials.blogspot.com 11 Jan 2012 | 11:54 pm

Limited SQL Server 2000 DTS Functionality on 64-bit Operating Systems SQL Server 2008 does not include support for DTS in the following circumstances: There is no 64-bit design-time or run-time supp...

Reusable SQL function to split a string venkataspinterview.blogspot.in 13 Jul 2011 | 05:21 am

All Questions ASP.NET CSharp SQL Server All Questions WCF MVC HR Round Search This Site Write a reusable split function that can be used to split any given string with a given delimiter? To furthe...

SQL Server 2012 : New TSQL Features smsaxena.blogspot.in 22 May 2012 | 03:03 am

New T-SQL Features in SQL Server 2012 /* 1.  IIF  Function*/ DECLARE @a int = 10; DECLARE @b int = 40; SELECT IIF ( @a > @b, 'TRUE', 'FALSE' ) AS Result; /* 2. CHoose  Function*/ SELECT CHOOSE (...

User Defined Function in SQL Server codebarlet.com 3 Feb 2012 | 02:44 am

User Defined Function in SQL Server In this article you will read and understand the types of User Defined Functions or shortly called UDFs, how to create UDFs and how to use them. There are 3 types ...

convert() function in sql codebarlet.com 10 Jan 2012 | 12:31 am

This function in sql server is used for mostly two reasons; to convert one datatype into another datatype or for conversion of date/time formats. So you can convert integer to varchar, varchar to date...

Microsoft SQL Server Reporting dotnetdeveloper.us 31 Jan 2012 | 12:05 am

Create and manage customized SQL reports using our MS SQL expertise A database’s functionality and usefulness is only as good as the ease of accessing and presenting of the information stored in ther...

A Microsoft SQL Server DMV/DMF Cheat-Sheet opsvault.com 2 May 2012 | 12:00 am

Tweet I am asked this question by Microsoft SQL Server customers again and again: “What dynamic management views (DMV) or dynamic management functions (DMF) should I use?” The short answer is, as man...

insertintodb.blogspot.com 29 Jan 2009 | 05:48 am

I am facing a huge problem. I did a registration page and i want to store the data into SQL Server. I created two stored procedures in SQL and two functions in visual basic to call the stored procedur...