Viewing 15 posts - 1,321 through 1,335 (of 6,036 total)
rajemessage 14195 (7/3/2016)
please tel me some key words , show that i will search in my stored prcedure
TRY -- CATCH ?
July 4, 2016 at 5:58 pm
Do you have something like
DECLARE @SomeVar = dbo.SomeFunction(@param1, ...)
in the code of the procedure?
July 3, 2016 at 9:53 pm
SQL-DBA-01 (7/3/2016)
Per the link : "http://www.sqlshack.com/the-dbas-guide-to-stretch-database/"Below are the data types which are not supported:
filestream
timestamp
sql_variant
XML
geometry
geography
hierarchyid
CLR user-defined types (UDTs)
-- Considering this I was thinking why not "dateoffset", in place of text/image?
Apparently, the...
July 3, 2016 at 8:05 pm
panneermca35 (6/30/2016)
Hi,I have stored image as binary data type and i want to generate as html content for report purpose.
This task has nothing to do with SQL.
You need an OCR...
June 30, 2016 at 10:26 pm
Chuck Bevitt (6/30/2016)
I think a light is starting to come on - what I was looking at as a simple read query...
June 30, 2016 at 9:23 pm
ScottPletcher (6/30/2016)
Jeff Moden (6/24/2016)
Shifting gears a bit and depending on how that's used, it could become a performance problem due to the implicit conversions of the string literals. Since...
June 30, 2016 at 9:18 pm
Wow!
That's a big bunch of code!
Compare to this (using the table I've posted above):
DECLARE @StartDate SMALLDATETIME, @EndDate DATE, @WeekStartsFrom VARCHAR(50)
SET @StartDate = '20160501'
SET @ENDDATE = '20160531'
SET @WeekStartsFrom = 'Saturday'
SELECTMIN(Date)...
June 30, 2016 at 6:43 pm
David92595 (6/28/2016)
I am trying to dynamically update a table (as much as possible) based on a parameter. However, because I'm trying to avoid SQL injection I'm hard coding the table...
June 29, 2016 at 8:45 pm
DECLARE @TheDateTime DATETIME
SET @TheDateTime = '20160630 20:21:22'
SELECT CASE WHEN @TheDateTime = CAST(CAST (@TheDateTime AS NVARCHAR(50)) AS datetime) THEN 'All Correct' ELSE 'Fail!' END [Cast performance],
CASE WHEN @TheDateTime = CONVERT(DATETIME, CONVERT...
June 29, 2016 at 4:59 pm
rajemessage 14195 (6/28/2016)
1)There are many applications which send queries to database , and they could be unparameteris ones.
How do you define the difference between parametrised and unparametrised...
June 29, 2016 at 4:46 pm
Steve Jones - SSC Editor (6/29/2016)
Arrggghhhh, my idiocy here. I didn't check the box for HierarchyID.Points awarded back.
My apologies.
No, idiocy is not yours here.
Yours is a simple mistake, a typo.
Idiocy...
June 29, 2016 at 4:33 pm
I feel sorry for millions of other Kardashians who live in and (mainly) outside of USA.
They do not have any chance to get on the news.
Unless they change their last...
June 29, 2016 at 4:07 pm
drew.allen (6/29/2016)
Sergiy (6/28/2016)
Your problem is here:
' where RequestDate >= ''' + CAST(@RequestDate as nvarchar(23)) + ''''1. Never use CAST is SQL, especially for date-time related data types.
I disagree. ...
June 29, 2016 at 3:29 pm
From the explanation:
The other big restriction is on CLR types, which include hierarchyid and spatial types
Seems like the absence of hierarchyid from the "correct answer" list is just a mistake.
June 29, 2016 at 1:11 am
EamonSQL (6/24/2016)
Thanks alot, that works.I think though upgrading our server is probably the real answer!
Following data normalisation rules - that's your real answer.
June 29, 2016 at 12:53 am
Viewing 15 posts - 1,321 through 1,335 (of 6,036 total)