I am implementing in this way. is it correct?

Please suggest

Declare @message1 nvarchar(100) = 'Invalid Voucher Type',

@message2 nvarchar(100) = 'Invalid Voucher Number',

@message3 nvarchar(100) = 'Invalid Denomination Number',

@message4 nvarchar(100) = 'Invalid TransactionID',

@message5...

Easy one for end of the week 😛

+1

Jason-299789 (3/28/2013)

---

No you don't need to restart SQL server if you change the Max Server Memory setting it should automatically adjust to the new level.

Out of curiosity did you...

Hi Sohan, I tried your query but its not returning any value

DBCC FREEPROCCACHE

DBCC DROPCLEANBUFFER

run this.. it will help you

You can also use this --

Create table #temp

(

name varchar(20)

)

insert into #temp

values ('aaa'),('aa cd ef'),('abcd')

select * from #temp

where name like '% cd%'

You can use CHARINDEX or PATINDEX for this...

Good one 🙂

+1 😛

good question for the day 🙂

please provide table structure

Why today there are no replies from people? :w00t::w00t:

+1 today 🙂

Last time for DELETE cascade question I lose the points so this time first I prefer to refer BOL before answering this question 😛

dwain.c (3/24/2013)

---

I'll...

This wil also give error :

DROP FUNCTION dbo.Test DROP TYPE dbo.MyTable GO

as GO is present at the same line where it should not be....

Alas I got wrong :w00t:

lolz of discussion 😛

------------------------------------------------

Visit my blog :

http://sqlpassionate.blogspot.in/