sql server - Setting a variable to a certain value or default to all values in a column -


sorry if heading clear. trying create stored procedure :

create procedure pro1 @a nvarchar = null, @b nvarchar =null select * table1 parameter1 = '1' , parameter2 = @a go

above not actual code hope explains trying achieve. selecting on 2 parameters. 'parameter2' depends on variable @a. challenge have if @a remains null @ execution; want select statement search on values of parmeter2 if 'and' statement not there. write if else statement execute different selects hoping set @a sort of wildcard value this? maybe : 'like []'?

create procedure dbo.pro1 -- use schema prefix when creating objects!   @a nvarchar(32) = null -- 32 should match data type of parameter2 column begin -- wrap body , indent readability   set nocount on; -- should turn off done_in_proc messages    select columns -- please name columns instead of select *     dbo.table1 -- use schema prefix when referencing objects     (parameter2 = @a or @a null); -- semi-colons please! end go

in cases may find if have lot of these optional parameters, sql server compile plan 1 set of parameters , plan not beneficial different parameters. may want this:

create procedure dbo.pro1   @a nvarchar(32) = null begin   set nocount on;    declare @sql nvarchar(max);    set @sql = n'select columns dbo.table1 1=1';    if @a not null     set @sql += ' , parameter2 = @a';    exec sp_executesql @sql,     n'@a nvarchar(32)',     @a; end go

Comments

Post a Comment

Popular posts from this blog

How to mention the localhost in android -

i trying call localhost in android application. unfortunately not possible used several methods emulator local host http://10.0.2.2/android/dbconnection.php and network ip address http://192.168.1.xx/android/dbconnection.php also http://localhost:8080/android/dbconnection.php but nothing connected localhost. purpose refer stackoverflow answers not working i facing same problem when worked on localhost. referred stackoverflow answer got solution create new emulator works fine in new emulator.
Read more

php - Calling a template part from a post -

i include iframe within post in wordpress. located inside content of post, meaning cannot in post template file, otherwise either before or after. i'd add facebook plugin within posts: <div id="socialwrap"><div class="fb-like" data-href="http://onlinearizonahomes.info" data-send="true" data-width="450" data-show-faces="true" data-font="arial"></div></div> i thinking of calling template part within post <?php get_template_part( 'social' ); ?> cannot use php within post without plugin (i'd avoid using plugin this). an alternative using javascript create html in post, seems unnecessary use of javascript. what best way add html within wordpress post? you can use shortcode. add functions.php function cudjex_fbshare( $atts, $content = null ) { global $post; $link = get_permalink($post->id); return '<div id="socialwrap...
Read more

c# - String.format() DateTime With Arabic culture -

check below code snippet, namespace testdateconvertion { class program { static void main(string[] args) { datetime testvalue = new datetime(2013, 12, 15, 15, 33, 44); cultureinfo culture = new cultureinfo("ar-sa"); string stringvalue = string.format(culture, "{0:d} {0:hh:mm:ss}", testvalue); console.writeline(stringvalue); console.readline(); } } } it gives output 22/02/35 15:33:44 i not getting how possible. whats 35 doing in output there that's 13/12/2015 in hijri, 35 means 1435 in hijri, default date format saudi arabia.
Read more