Script Generator
It is a modified version of original script I found on net. This script creates conditional Update statements too.
2007-07-05 (first published: 2006-10-03)
510 reads
It is a modified version of original script I found on net. This script creates conditional Update statements too.
2007-07-05 (first published: 2006-10-03)
510 reads
This is another type of split function which disects 8000 byte varchar with given delimeter and returns table with disected values.It does that with single select statement (internally looped), without using explicit while loop.Works pretty fast
2007-02-06 (first published: 2006-08-18)
387 reads
By Steve Jones
Today’s coping tip is to take a small step towards and important goal. One...
By SQLBalls
Hello Dear Reader! It's been a while since I had time to sit down...
I was writing some dynamic SQL that generates some SQL statements to load my...
I am parameterizing an sql server connection. There are the following fields: username password...
Please assist. I am getting the above error: CREATE VIEW DailyAccountBalances AS SELECT DATE(TransactionDate)...
Hello, I'm pretty new to SSIS, but I have an Excel source that I...