Viewing 15 posts - 5,071 through 5,085 (of 26,490 total)
Jonathan AC Roberts (6/4/2015)
SELECT *...
June 4, 2015 at 10:30 am
My car is making a funning noise, please fix it.
That's about what you posted above. How about posting the full and complete error message you are getting.
June 4, 2015 at 10:14 am
WhiteLotus (6/3/2015)
Lynn Pettis (6/3/2015)
Did you provide the entire error message from the error log or just a summary?
thx for the reply
in sql error log only says
Error :...
June 4, 2015 at 10:05 am
Alvin Ramard (6/4/2015)
Jeff Moden (6/4/2015)
Have any of you ever used a CTP of SQL Server to power your real production databases? Personally, I think such a...
June 4, 2015 at 9:57 am
HLogic (6/4/2015)
nycdotnet (6/18/2013)
Interesting article. Regarding the paradox of semicolons on CTEs - the rule is "the statement before the CTE has to end with a semicolon".
I believe...
June 4, 2015 at 9:54 am
GilaMonster (6/4/2015)
*sigh*I swear some people don't actually want help.
This wouldn't happen to be the thread where the OP edited all their posts to "nil" is it?
June 4, 2015 at 8:37 am
Did you provide the entire error message from the error log or just a summary?
June 3, 2015 at 8:35 pm
Dan121 (6/3/2015)
My question is:
Is there alternative (best) solution for this? ( database AdeventureWorks, table Sales.Customer). In my case, StoreID, AccountNumber and rowguid have duplicate values.
select *...
June 3, 2015 at 1:45 pm
From what table are we to pull the order number? You have only provided half the needed information.
June 3, 2015 at 12:57 pm
N_Muller (6/3/2015)
I'm actually using SQL 2014. Anyhow, thanks for the advice. I'll look into that as I never used FILESTREAM.
Check out FileTables as well. They were introduced in...
June 3, 2015 at 12:50 pm
Since it appears you are using SQL Server 2008 based on the forum you posted your question, I would suggest looking into FILESTREAM, https://msdn.microsoft.com/en-us/gg471497.aspx and https://technet.microsoft.com/en-us/library/bb933993(v=sql.105).aspx.
June 3, 2015 at 10:51 am
In MS SQL Server the CASE is not used for flow control. Your original post shows that you are attempting to control the flow of execution. What are...
June 2, 2015 at 3:59 pm
Alan.B (6/2/2015)
fliteskates (6/1/2015)
Eric M Russell (6/1/2015)
fliteskates (5/29/2015)
I am trying to learn how to use SQL and I have downloaded MSSQL Server 2014 Express. I am a complete beginner with...
June 2, 2015 at 1:04 pm
SMH...
Why would the person who wrote the procedure ask on a public forum why his procedure is returning a value of -6 when executed?
June 2, 2015 at 12:16 pm
douglas.allison1 (6/2/2015)
Hi All,I am running a sproc we have developed and I am getting a -6 as a returned value does anyone know what that actually means.
TIA
Doug
Since we can't see...
June 2, 2015 at 9:33 am
Viewing 15 posts - 5,071 through 5,085 (of 26,490 total)