Viewing 15 posts - 901 through 915 (of 13,465 total)
franklinkeith (6/17/2016)
static number (12345) + ID number
SELECT 12345[highlight="#ffff11"]00000[/highlight] + ID, so as long as your Id is less than 99999, it fits your criteria.
June 17, 2016 at 6:23 am
sunil.mvs (6/15/2016)
Team started working on SQL Server 2014 and TFS .
They developed packages using project deployment...
June 17, 2016 at 6:00 am
SQLPain (6/15/2016)
June 17, 2016 at 5:53 am
Lowell (6/15/2016)
services consume licenses, but tools and connectivity do not. that's reinforced by the same tools being part of a separate downloadable install package.
only when...
June 15, 2016 at 8:21 am
my understanding is similar to George's:
services consume licenses, but tools and connectivity do not. that's reinforced by the same tools being part of a separate downloadable install package.
only when you...
June 15, 2016 at 8:10 am
you keep missing the point about how tables do not have a natural or default order in SQL server.
they are treated as unordered rows of data.
all the rows are...
June 15, 2016 at 6:22 am
there is a paid oledb provider from cherrycitysoftware.com(since they cost $, i will not bother with a link) ; with that you could create a linked server or import via...
June 15, 2016 at 5:58 am
we need an example of duplicates making it in.
when i test, i get an error violating the PK, which would be expected.
insert into [Test_A]([V],[CA])SELECT '1','2'
insert into [Test_A]([V],[CA]) SELECT '1','2'
Msg 2627,...
June 14, 2016 at 2:39 pm
ok, in that case, i would cross join the default value, and select it in the isnull:
SELECT M.member_name,
M.member_plan,
...
June 14, 2016 at 1:54 pm
great job on providing sample data.
it looks like a simple isnull is needed, am i right?
SELECT M.member_name,
M.member_plan,
...
June 14, 2016 at 1:36 pm
brad.mason5 (6/14/2016)
Have issues with icons not displaying?
On a side note: How do you add images to the body? I add as...
June 14, 2016 at 1:16 pm
it also looks to me like you could combine the WHERE statement into a single query, that might be more efficient too:
aww nevermind, i didn't notice the IS NOT NULL...
June 14, 2016 at 11:57 am
create a role, and then grant execute to the role; don''t grant on a per object basis, and you'll be fine.
as long as the proc uses objects only in the...
June 14, 2016 at 11:50 am
the first handful of articles from my search points to networking issues, and not anything with SQL server itself.
[this article mentions Distributed Transaction Coordinator on the remote linked server...
June 13, 2016 at 12:54 pm
dschlobohm (6/13/2016)
then get this error
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or...
June 13, 2016 at 12:02 pm
Viewing 15 posts - 901 through 915 (of 13,465 total)