Lynn Pettis

Forum Replies Created

Viewing 15 posts - 931 through 945 (of 26,486 total)

RE: error concatenating parameter inside exec

scotsditch - Friday, September 28, 2018 12:25 PM
The two examples below are a simplified version of an error I'm running in to....

September 28, 2018 at 12:51 pm

#2007403
RE: sql server does not seem to have an equivalent of Oracle %ROWTYPE ?

DesNorton - Friday, September 28, 2018 12:09 PM
Lynn Pettis - Friday, September 28, 2018 9:45 AM

September 28, 2018 at 12:47 pm

#2007402
RE: sql server does not seem to have an equivalent of Oracle %ROWTYPE ?

ZZartin - Friday, September 28, 2018 10:13 AM
Lynn Pettis - Friday, September 28, 2018 9:58 AM

September 28, 2018 at 10:30 am

#2007392
RE: sql server does not seem to have an equivalent of Oracle %ROWTYPE ?

sgmunson - Friday, September 28, 2018 9:52 AM
Lynn Pettis - Friday, September 28, 2018 9:45 AM

September 28, 2018 at 9:58 am

#2007387
RE: sql server does not seem to have an equivalent of Oracle %ROWTYPE ?

Lynn Pettis - Friday, September 28, 2018 9:45 AM
sgmunson - Friday, September 28, 2018 9:34 AM

September 28, 2018 at 9:51 am

#2007382
RE: sql server does not seem to have an equivalent of Oracle %ROWTYPE ?

sgmunson - Friday, September 28, 2018 9:34 AM
Perhaps more importantly, what would you do with the information if you could actually get...

September 28, 2018 at 9:45 am

#2007380
RE: Conversion error

wmg - Friday, September 28, 2018 8:54 AM
The problem is that you're trying to concatenate a datetime to a string. Cast @STARTTIME...

September 28, 2018 at 9:13 am

#2007377
RE: How to use HASHBYTES function in sql server for multiple columns

Scott In Sydney - Thursday, September 27, 2018 6:49 PM
vikasjagadale8 - Wednesday, September 26, 2018 12:38 PM

September 28, 2018 at 8:37 am

#2007374
RE: Finding when date changes for customer in table

mnovosel - Thursday, September 27, 2018 6:22 PM
jcelko212 32090 - Thursday, September 27, 2018 5:10 PM

September 28, 2018 at 8:35 am

#2007373
RE: Choosing columns for Clustered Index.. Why it is so important?

Brahmanand Shukla - Thursday, September 27, 2018 9:01 AM
I have written my own blog
https://brahmanand.tech.blog
Reread number 1 and it is an agree/strongly...

September 27, 2018 at 1:26 pm

#2007303
RE: Choosing columns for Clustered Index.. Why it is so important?

Brahmanand Shukla - Thursday, September 27, 2018 9:01 AM
I have written my own blog
https://brahmanand.tech.blog
And #29 Avoid Dynamic SQL.
Dynamic SQL is a tool. ...

September 27, 2018 at 1:23 pm

#2007302
RE: Choosing columns for Clustered Index.. Why it is so important?

Brahmanand Shukla - Thursday, September 27, 2018 9:01 AM
I have written my own blog
https://brahmanand.tech.blog
And yes, I also disagree with #21 Donâ€™t use...

September 27, 2018 at 1:18 pm

#2007301
RE: Choosing columns for Clustered Index.. Why it is so important?

Brahmanand Shukla - Thursday, September 27, 2018 9:01 AM
I have written my own blog
https://brahmanand.tech.blog
I also disagree with #17 Tables whose columns are...

September 27, 2018 at 1:15 pm

#2007300
RE: Choosing columns for Clustered Index.. Why it is so important?

Brahmanand Shukla - Thursday, September 27, 2018 9:01 AM
I have written my own blog
https://brahmanand.tech.blog
I will disagree with #6

September 27, 2018 at 1:00 pm

#2007294

Viewing 15 posts - 931 through 945 (of 26,486 total)