Passing datetime as a parameter to SQL Stored procedure in Query Analyzer

By Sigar Dave No comments

Yesterday I faced problem passing datatime parameter in sql server queryanalyzer, where I was trying to run a procedure UP_ORDER_LOG which expects parameter @co_id, @Prog_id, @event and @event_date So I tried executing the procedure like exec UP_ORDER_LOG @co_id='XYZ', @prog_id='ABC', @event='Some event', @event_date=getdate() exec UP_ORDER_LOG @co_id='XYZ', @prog_id='ABC', @event='Some event', @event_date=getdateexec UP_ORDER_LOG @co_id='XYZ', @prog_id='ABC', @event='Some event', @event_date=CURRENT_TIMESTAMP […]

Passing datetime as a parameter to SQL Stored procedure in Query Analyzer

By Sigar Dave No comments

Yesterday I faced problem passing datatime parameter in sql server queryanalyzer, where I was trying to run a procedure UP_ORDER_LOG which expects parameter @co_id, @Prog_id, @event and @event_date So I tried executing the procedure like exec UP_ORDER_LOG @co_id='XYZ', @prog_id='ABC', @event='Some event', @event_date=getdate() exec UP_ORDER_LOG @co_id='XYZ', @prog_id='ABC', @event='Some event', @event_date=getdateexec UP_ORDER_LOG @co_id='XYZ', @prog_id='ABC', @event='Some event', @event_date=CURRENT_TIMESTAMP […]

Tips for Writing High-performance SQL Query

By Sigar Dave No comments

These tips apply broadly when writing high-performance stored procedures. Unfortunately, unlike some tips, you can't simply apply most of them without first considering the nature and schema of the data you're querying.1. Avoid using cursors (as well as other looping structures) as much as possible. Cursors are inefficient, and database engines usually don't have the […]

Tips for Writing High-performance SQL Query

By Sigar Dave No comments

These tips apply broadly when writing high-performance stored procedures. Unfortunately, unlike some tips, you can't simply apply most of them without first considering the nature and schema of the data you're querying.1. Avoid using cursors (as well as other looping structures) as much as possible. Cursors are inefficient, and database engines usually don't have the […]

Create 3 color gradient in CSS with online tool

By Sigar Dave No comments

Posted: 22 Jul 2010 11:20 PM PDT If you are starting off learning CSS, online tools to create CSS code are quite useful. Recently I wrote about creating CSS borders without coding knowledge which was useful for the amateur. I found another nice tool to create 3 color gradients in CSS with an online website. […]

Create 3 color gradient in CSS with online tool

By Sigar Dave No comments

Posted: 22 Jul 2010 11:20 PM PDT If you are starting off learning CSS, online tools to create CSS code are quite useful. Recently I wrote about creating CSS borders without coding knowledge which was useful for the amateur. I found another nice tool to create 3 color gradients in CSS with an online website. […]

Google Search for Hackers, Pirates and Klingons

By Sigar Dave No comments

Posted: 21 Jul 2010 05:53 AM PDT Are you a hacker? If you are geek then chances are you have searched Google for hacking tools. Chances are most geeks do not end up being Hackers but only fantasizing about it. Code is very important to geeks who are programmers and Google is full of them. […]

Google Search for Hackers, Pirates and Klingons

By Sigar Dave No comments

Posted: 21 Jul 2010 05:53 AM PDT Are you a hacker? If you are geek then chances are you have searched Google for hacking tools. Chances are most geeks do not end up being Hackers but only fantasizing about it. Code is very important to geeks who are programmers and Google is full of them. […]

Google images search gets swanky!

By Sigar Dave No comments

Posted: 21 Jul 2010 12:30 PM PDT Google Search is fast becoming a favorite place for internet users to look up images online. Often we bloggers use Google image search for looking up cool images. For some reason as all things Google, its image search layout of images is quite basic and functional. Seriously Google should have […]

Google images search gets swanky!

By Sigar Dave No comments

Posted: 21 Jul 2010 12:30 PM PDT Google Search is fast becoming a favorite place for internet users to look up images online. Often we bloggers use Google image search for looking up cool images. For some reason as all things Google, its image search layout of images is quite basic and functional. Seriously Google should have […]

  • 1
  • 2