MS SQL
How to import Excel into MS SQL
First, forget about importing Excel into MS SQL, it is to time consuming to get it right. You are better of converting the Excel file to a simple CSV file, change the setting to a large string value for the columns, import it into MS SQL and then convert the field types to the proper [...]
Read Full Post | Make a Comment ( 1 so far )Saving change is not permitted MS SQL 2008
Been battling with MS SQL 2008 and ran across the issue (it’s actually a feature!) of not being able to save changes made to a table in designer view. I got the following error:
Saving change is not permitted. the changes you have made require the following tables to be dropped and re-created. You have either [...]
MS SQL Date Time to Epoch
I know it’s been a while for you programmers out there, but here is an MS SQL function that converts Date Time to Epoch.
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER FUNCTION [dbo].[fn_dateTimeToEpoch] (
@dateTime DATETIME
)
RETURNS BIGINT
AS
BEGIN
DECLARE @epochDay BIGINT
DECLARE @epochSecond INT
– epoch ‘01-01-1900 00:00:00′
– one day 86400 seconds
SET @epochDay = DATEDIFF( day, ‘01-01-1900 00:00:00′, @dateTime )
– get the remainder
SET [...]
Create a Google Webmaster Sitemap (free code)
Want to know how to easily create a Google sitemap without having to use any other external tools?
It’s easypeasy if you use MS SQL and ColdFusion!
Let’s assume you have a database full of products (11,000 or more) and you need to generate a sitemap so google knows what to index. You wouldn’t want to do that [...]
ColdFusion tutorial to create same hash as CF, but in MS SQL!, directly in the MS SQL RDMBS?
How cool would it be, being able to create the same MD5 hash as ColdFusion, directly in the MS SQL RDMBSH?
I know there’s been quite some demand for this function, most people create the MD5 hash in ColdFusion and then pass it the Database, this mean a couple more round trips to the db, which [...]
ColdFusion tutorial to export from database to RSS
Always wanted to export items from your existing database into RSS with ColdFusion and syndicate it, but don’t know how?
Well, this is your lucky day! We’re going to show you how you can easily export your database records to RSS.
Read Full Post | Make a Comment ( None so far )