Lynn Pettis

Forum Replies Created

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

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