Showing posts with label sql2008. Show all posts
Showing posts with label sql2008. Show all posts
Monday, June 15, 2015

Grouping Datetime Column by Date part only.

›
SELECT DATEADD(dd,(DATEDIFF(dd,0,CRETS)),0), COUNT(*) FROM Table1 GROUP BY DATEADD(dd,(DATEDIFF(dd,0,CRETS)),0) SELECT CAST(DATEDIFF(dd...
Friday, January 15, 2010

Import from Excel Sheet into Sql Table with filtering

›
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\Data.xls', 'S...
Monday, June 15, 2009

SQL FUNCTION ExtractNumbers

›
SQL FUNCTION ExtractNumbers Create Function ExtractNumbers ( @str_passed varchar(max) ) Returns varchar(50) AS BEGIN     declare @val varch...
Monday, February 9, 2009

Scalar User Defined Functions and Computed Columns

›
Scalar User Defined Functions and Computed Columns Came across an interesting SQL problem where a customer has a table with a primary key an...
Tuesday, February 3, 2009

Convert an Integer/Number into words

›
SET NOCOUNT ON ============================================= Description: Converts an integer into words , viz., -- master.dbo.fnSpellInteg...
1 comment:
Tuesday, January 27, 2009

How to increase the size of a database (Enterprise Manager)

›
How to increase the size of a database (Enterprise Manager) To increase the size of a database Expand a server group, and then expand a serv...
1 comment:

How to Get Available space on Database

›
How to Get Available space on Database using a Dynamic Query:- EXEC(N'USE ' + @dbname + N' select  [FILE_SIZE_MB] =            c...
Tuesday, January 13, 2009

Create A Comma Delimited List From a Column

›
Create A Comma Delimited List From a Column Create Sample Data for Both Solutions -- Suppress data loading messages SET NOCOUNT ON -- Crea...

ISNULL() and COALESCE()

›
ISNULL() and COALESCE() In dealing with NULL values in SQL Server, the developer is often faced with the requirement to evaluate the content...

SQL2008: Lock a Stored Procedure for Single Use Only

›
SQL2008: Lock a Stored Procedure for Single Use Only Create a Custom Error Message, Designating an User assigned Error Number, starting at 5...

Finding the Last Occurrence of a Pattern in a String

›
When dealing with string data, one of the most useful Transact-SQL functions you can have in your toolbox is  PATINDEX . Aside from it’s man...
Monday, January 12, 2009

How do you find out all the IDENTITY columns of all the tables in a given database?

›
How do you find out all the IDENTITY columns of all the tables in a  given database? SELECT '[' + TABLE_SCHEMA + '].[' + TAB...

Differences Between SQL Server 2000 and 2005

›
Feature SQL Server 2000 SQL Server 2005 Server Programming Extensions Limited to extended st...

Sql Split function

›
CREATE   FUNCTION  Split (      @StringToSplit  varchar (2048),      @Separator  varchar (128) ) RETURNS   TABLE   AS   RETURN WITH  CTE  AS...

Import Data from Excel File to sql datatable

›
Import Data from Excel File to sql datatable To Export Data Form an Excel file, there is one drawback lying behind them. The Sheet1 from the...

Import Data from Excel File to sql datatable

›
Import Data from Excel File to sql datatable As I has stated in my previous post regarding to Export Data Form an Excel file, there is one d...