Jonathan AC Roberts

Forum Replies Created

Viewing 15 posts - 2,161 through 2,175 (of 2,648 total)

RE: How to build an app with GUI that works with SQL Server?

elea.grig - Sunday, September 30, 2018 7:24 AM
I have to create a project which should have a GUI because people who gonna...

October 1, 2018 at 8:52 am

#2007521
RE: insert the records in Table 2 whenever the records delete in Table 1.

below86 - Monday, October 1, 2018 8:28 AM
Jeff Moden - Monday, October 1, 2018 8:04 AM

October 1, 2018 at 8:38 am

#2007515
RE: Compress and Decompress in SQL Server 2016

BrainDonor - Monday, October 1, 2018 3:11 AM
Nice article but testing of this function is a must. When looking into these commands...

October 1, 2018 at 4:52 am

#2007473
RE: Loop through resultset, update table and remove trailing and leading spaces.

Scott Coleman - Monday, September 24, 2018 2:34 PM
Do you consider it extra effort to type LTRIM(RTRIM()) instead of TRIM()?
Unless you're generating...

September 24, 2018 at 3:31 pm

#2006835
RE: Loop through resultset, update table and remove trailing and leading spaces.

NewBornDBA2017 - Monday, September 24, 2018 10:23 AM
I have a query which generates a SQL which I then copy and paste in...

September 24, 2018 at 1:03 pm

#2006807
RE: SQL Server stored procedures fast in SQL but slow when called by ASP.NET

jkramprakash - Sunday, September 23, 2018 4:37 AM
Query inside the stored procedure giving result fast (twenty seven thousand records in 2 seconds)...

September 24, 2018 at 6:44 am

#2006721
RE: Are the posted questions getting worse?

TomThomson - Sunday, September 23, 2018 6:20 PM
patrickmcginnis59 10839 - Tuesday, September 18, 2018 6:55 AM

September 24, 2018 at 5:34 am

#2006702
RE: Convert Date

Jeff Moden - Friday, September 21, 2018 9:22 AM
Jonathan AC Roberts - Friday, September 21, 2018 9:04...

September 21, 2018 at 9:51 am

#2006599
RE: move sql database files to bigger drive

HBK_4700 - Friday, September 21, 2018 9:29 AM
Hi, I am in a situation of refreshing a lower environment database with production backup....

September 21, 2018 at 9:35 am

#2006592
RE: Convert Date

Jeff Moden - Friday, September 21, 2018 8:41 AM
Jonathan AC Roberts - Friday, September 21, 2018 7:06...

September 21, 2018 at 9:04 am

#2006588
RE: Convert Date

below86 - Friday, September 21, 2018 7:50 AM
You could try this:
CONVERT(CHAR(11), DateIn, 107) AS DateIn
That's nearly there but it also adds a...

September 21, 2018 at 8:07 am

#2006565
RE: Convert Date

craig.jenkins - Friday, September 21, 2018 6:53 AM
Hi Guys,
Is there a way to convert the Datein in the below to show this...

September 21, 2018 at 7:06 am

#2006544
RE: Help on query

Have you tried using DBCC CHECKCONSTRAINTS?

September 21, 2018 at 4:27 am

#2006533
RE: Shrink data file issue

WhiteLotus - Monday, September 17, 2018 7:52 PM
Hi All
I shrank data file in a production database . at first the size...

September 21, 2018 at 3:50 am

#2006530
RE: COUNT(*) returns wrong value

sk 939 - Thursday, September 20, 2018 12:38 AM
Hi
I have some difficulties getting a COUNT(*) on my below SQL Query, atleast one...

September 20, 2018 at 3:44 pm

#2006504

Viewing 15 posts - 2,161 through 2,175 (of 2,648 total)