Viewing 15 posts - 631 through 645 (of 1,048 total)
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...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
March 29, 2013 at 4:12 am
Easy one for end of the week 😛
+1
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
March 28, 2013 at 10:53 pm
Jason-299789 (3/28/2013)
Out of curiosity did you...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
March 28, 2013 at 12:57 am
sohan.fegade (3/28/2013)
Try -SELECT*
FROMTableA
WHEREPATINDEX('%[ ]cd[ ]%', [Values]) > 0
OR PATINDEX('%[ ]cd', [Values]) > 0
OR PATINDEX('cd[ ]%', [Values]) > 0
Hi Sohan, I tried your query but its not returning any value
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
March 28, 2013 at 12:27 am
DBCC FREEPROCCACHE
DBCC DROPCLEANBUFFER
run this.. it will help you
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
March 28, 2013 at 12:22 am
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%'
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
March 28, 2013 at 12:17 am
You can use CHARINDEX or PATINDEX for this...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
March 27, 2013 at 11:46 pm
Good one 🙂
+1 😛
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
March 27, 2013 at 11:24 pm
good question for the day 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
March 26, 2013 at 11:25 am
please provide table structure
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
March 26, 2013 at 6:30 am
Why today there are no replies from people? :w00t::w00t:
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
March 26, 2013 at 3:23 am
+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 😛
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
March 25, 2013 at 11:39 pm
dwain.c (3/24/2013)
kapil_kk (3/24/2013)
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:
I'll...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
March 25, 2013 at 12:02 am
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:
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
March 24, 2013 at 11:23 pm
lolz of discussion 😛
------------------------------------------------
Visit my blog :
http://sqlpassionate.blogspot.in/
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
March 23, 2013 at 10:58 pm
Viewing 15 posts - 631 through 645 (of 1,048 total)