Posts Tagged ‘mssql’
SQL IF/WHILE Blocks – SQL For Programmers
September 30th, 2008 | 
Author: 
OK, all you programmer types. Here’s where SQL starts getting interesting. You have the basic concepts of declaring variables, setting up stored procedures, and doing a basic insert, update or delete statement. And if we stopped here, you’d probably be able to do 80% of the work you need to do.
You’d also start to wonder why you should even bother.
So now we tackle the basics of conditional programming in SQL.
Other Related Items:
Age of Empires II GoldMicrosoft Age of Empires II: Gold 2.0 Win32 English North America CD DVD Box Gold
Disney Club Penguin 2'' Mix 'N Match Figure Pack - Court Jester and KingIncludes throneUnlock Items Online with special coin2'' HPlasticAges 5+ImportedCollect all the 2'' Figure Packs for more Mix 'N Match fun, sold separately
3/4 hp 3450rpm 48Y Frame 115 volts "2-Speed" Square Flange Pool Pump Replacement Motor AO Smith #SQL1072RSquare Flange replacement inground pool pump motor. This is a 2 speed motor. Motor is found on many in ground pool pumps such as PacFab Challenger, Wh... Read More >
If you're new here, you may want to subscribe to the mailing list to get notifications of new post and a virtual tour of past topics. Thanks for visiting!
Posted in 
Tags: 
The easiest way to create a SQL db from Code
(We’ll get back to the series on Reflection next week.)
So, I’ve started experimenting with replacing my TestComplete test scripts with CSharp test scripts. This shouldn’t be too big of a deal since most of what I’m scripting are web applications and I can control that code via the WebBrowser control.
Well, the first thing my current script does is delete a database and recreate it. When I went looking for how to create a database, all I could find was code similar to this:
Other Related Items:
Simpsons World of Springfield Figure Series 12: DatabaseThis Series 12 Database figure is articulated and stand approximately 5" tall, and comes with exclusive accessories. When placed on a compatible World of Springfield playset, he comes to life and says one of several random phrases.
