Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Robert Marda » How Dynamic SQL Can Be Static SQL
Add to briefcase
12 posts, Page 2 of 2
««12

How Dynamic SQL Can Be Static SQL Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Robert W Marda
Posted Thursday, March 14, 2002 1:06 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, February 15, 2013 10:33 AM
Points: 976, Visits: 48
Yes the way tmorton suggested is certainly better. I got too caught up with using DATEPART and failed to find a simpler way.

Robert Marda



Robert W. Marda
SQL Programmer
Ipreo
Post #29608
Brian4
Posted Thursday, July 12, 2012 5:48 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 12, 2012 6:54 PM
Points: 1, Visits: 6
Hi,

I have a question regarding dynamic SQL / Static SQL.

I have written queries along with code in VB.NET & not in SP.

Example : SELECT * FROM TABLE WHERE COLUMN1 = ? AND COLUMN2 = ?

? are variables either string or int.

Above Query is Dynamic SQL or Static SQL?
Post #1329230
« Prev Topic | Next Topic »

Add to briefcase
12 posts, Page 2 of 2
««12

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.