Viewing 15 posts - 1,501 through 1,515 (of 4,087 total)
November 16, 2017 at 12:04 pm
But tThe RIGHT function is...
November 16, 2017 at 11:30 am
It's standard practice in many programming languages that if you need to include the string delimiter inside a string to use a double delimiter. So, you just need to double...
November 16, 2017 at 9:59 am
I think that you are looking to CREATE SYNONYM.
Drew
November 16, 2017 at 9:45 am
It's not just a language barrier. The expected results are logically inconsistent.
For example, this combination produces three results:
INSERT INTO #StateDistrict
VALUES
(1,40,50)
November 16, 2017 at 8:49 am
You're getting an error, because both sys.master_files and sys.databases have a column "name". Just specify which one you want in your select statement.
November 15, 2017 at 11:34 am
There are two main approaches, both of which have already been suggested. Which one performs better depends on the density of the child table (subscriptions) with respect to the parent...
November 15, 2017 at 9:21 am
November 15, 2017 at 7:52 am
/* THIS IS HOW YOU SET UP SAMPLE DATA */
/* 1) Create a table, preferably a temp table or table variable.
This...
November 14, 2017 at 9:37 am
November 14, 2017 at 8:41 am
Viewing 15 posts - 1,501 through 1,515 (of 4,087 total)