Viewing 15 posts - 1,426 through 1,440 (of 15,381 total)
Lynn Pettis (6/24/2016)
Sean Lange (6/24/2016)
Jeff Moden (6/24/2016)
Sean Lange (6/24/2016)
create view [dbo].[getNewID] as select newid() as new_id;
Really? A view to...
June 24, 2016 at 12:01 pm
Jeff Moden (6/24/2016)
Sean Lange (6/24/2016)
create view [dbo].[getNewID] as select newid() as new_id;
Really? A view to get a guid???
But wait...it...
June 24, 2016 at 10:45 am
Ugh....just needing to share this unbelievably ridiculous mess I just stumbled across.
create view [dbo].[getNewID] as select newid() as new_id;
Really? A view to get a guid???
But wait...it gets even better.
ALTER function...
June 24, 2016 at 10:17 am
ChrisM@Work (6/24/2016)
I've heard that the EU now has 1GB of free space.
Groan!!! But still pretty funny!!!
June 24, 2016 at 10:14 am
Charmer (6/23/2016)
The guy had told me clearly that we have permission to drop too.
Then the answer I...
June 23, 2016 at 7:48 am
Phil Parkin (6/23/2016)
tindog (6/23/2016)
HappyGeek (6/23/2016)
Spam on the rise again, really not interested in solid wood furniture!Not even at low low prices?
I wonder if that anti-aging serum works on old farts...
June 23, 2016 at 7:23 am
mastsetup (6/22/2016)
thank you 🙂 it worked on bot SQL server and Db2.
Glad that worked for you and thanks for letting me know.
June 22, 2016 at 12:55 pm
curious_sqldba (6/22/2016)
Thanks. This is just displaying, i want to store the data in the variable and then use the variable different places.
Do you know how to use a select statement...
June 22, 2016 at 9:50 am
Here is the concept posted by santiagoc93 using your sample data.
DECLARE @DBs TABLE ( DBname NVARCHAR(100) )
INSERT INTO @DBs
VALUES ( 'A' ),
...
June 22, 2016 at 9:22 am
durga.palepu (6/22/2016)
additional information:SQL Server 2016 offers new feature, STRING_SPLIT() which returns delimited strings as records.
e.g.
SELECT STRING_SPLIT('A,B,C',',')
Output:
A
B
C
While that is true it has no relevance in this question. The OP...
June 22, 2016 at 7:19 am
Sure this is possible. In the future it would be helpful if you could post the table and sample data in a consumable format. Since I see you are new...
June 22, 2016 at 7:11 am
Lynn Pettis (6/20/2016)
Sean Lange (6/20/2016)
Lynn Pettis (6/20/2016)
Sean Lange (6/20/2016)
Lynn Pettis (6/20/2016)
June 20, 2016 at 3:26 pm
Lynn Pettis (6/20/2016)
Sean Lange (6/20/2016)
Lynn Pettis (6/20/2016)
Does anyone else...
June 20, 2016 at 3:01 pm
Lynn Pettis (6/20/2016)
Does anyone else see a problem with...
June 20, 2016 at 2:43 pm
Ed Wagner (6/17/2016)
Sean Lange (6/17/2016)
Ed Wagner (6/17/2016)
Sergiy (6/16/2016)
My point was - the question about finding current time does not have a correct answer without specifying additional conditions.
And I think that's...
June 17, 2016 at 7:29 am
Viewing 15 posts - 1,426 through 1,440 (of 15,381 total)