The SQL Zone

The database server is the big iron in a server environment, and keeping them running smoothly is a full-time job. If you’re looking to improve your skills as a DBA or a database developer, this is the place to start.

The articles gathered in our SQL Server Zone cover everything from basic SQL syntax to advanced tuning techniques for stored procedures.

Alongside white papers and sample code, you can read articles for all levels of proficiency, and get answers for specific questions from the authors themselves. Your ongoing SQL Server learning begins here.

Red Gate Whitepapers

Featured Article

Introducing the Boomerang Framework

by psined

Introduction to Boomerang Framework

Articles

	Manage Your CRUD Operation by Faisal(mfrony) This Article will help you to manage our CRUD operation more efficient way
	SQLoogle - Part 1 of 2 by dale.newman Google your SQL.
	A mobile salon services solution. by Randall Smith II A simple solution trying out the Azure platform for development and deployment.
	SQL Server Functions that helps to convert date and time values to and from string literals and other date and time formats. by Shemeer NS CAST(), CONVERT(), PARSE(), TRY_PARSE(), TRY_CONVERT(), FORMAT(), SQL Server Functions, SQL...
	Comics Subscription Tracker by mf81 This will be a lightweight site that helps the user track their weekly comics subscriptions.
	COM Interoperability in .NET Framework: Part I by Prashant M. Tailor Using COM components in .NET framework.
	VB DataGridView Automatically Saving Updates to a Bound Database by Andrew Timberlake-Newell Demonstrates how to configure a DataGridView control to automatically store edits to bound...
	Multi-column dropdown combobox - an ASP.NET 2.0 server control by Gary Dryden Multi-column dropdown combobox - an ASP.NET 2.0 server control.
	Enumerate SQL Server Instances in C#, Using ODBC by earmitage An article on enumerating SQL Server instances in C# using ODBC thus removing any dependancy on...

Discussions

You must Sign In to use this message board.

Search this forum
	Profile popups Spacing Noise Layout Per page

Using float and like

berba

2 Jul '12 - 0:54

Hi, Can the following be used in a stored procedure? convert(float, (columnname))like @x I've tried it. It works. Wanted to know if it's a good way of programming? Cheers Berba
Sign In·Permalink

Re: Using float and like

Pete O'Hanlon

2 Jul '12 - 2:52

As you will be converting the value of each item in columnname to `float`, this is a more expensive operation than converting the value in `@x` into the appropriate type. pre-emptive celebratory nipple tassle jiggle - Sean Ewington "Mind bleach! Send me mind bleach!" - Nagy Vilmos CodeStash - Online Snippet Management \| My blog \| MoXAML PowerToys \| Mole 2010 - debugging made easier
Sign In·Permalink

Re: Using float and like

PIEBALDconsult

2 Jul '12 - 6:59

And then they're converted to string, which is worse.
Sign In·Permalink

Re: Using float and like

PIEBALDconsult

2 Jul '12 - 7:04

berba wrote:
if it's a good

Most likely not; all those conversions will kill you. What are you trying to do? Perhaps you want BETWEEN?

As mentioned, converting the parameter value (once) is much better* than converting all the values in the column.

* Anecdote: I once inherited maintenance of a batch program that took forty minutes to run; after fixing the conversions it took only ten minutes.

General News Suggestion Question Bug Answer Joke Rant Admin

Red Gate Resources

Free eBooks

Product Announcements

Advertise | Privacy | Mobile
Web02 | 2.6.130523.1 | Last Updated 1 Aug 2007

Layout: fixed | fluid

		9,890,640 members (50,399 online) Visit CodeProject.TV Discuss CodeProject.TV Sign in Email Password Forgot your password? Sign in using