Test Driven Development (TDD)

RE: Script to Change Standard SQL Account Passwords

• by SQLBill

• SimpleTalk

• Reply

This is a duplicate post and has already been answered.http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=6&messageid=115242-SQLBill

2004-05-13

RE: order by w/ NULL at bottom

• by James Travis

• SimpleTalk

• Reply

Best place of course is to start in BOL.

2004-05-07

RE: date range query

• by Razvan-Socol

• MSSQLTips.com

• Reply

You should know that using CONVERT will prevent SQL Server to use any indexes. If the table is large and you want to use an index on the supp_startdt, you should use the method that Jeff suggested.Razvan

2004-04-30

RE: Import File Methadology

• by BigG

• SimpleTalk

• Reply

Hi,Without knowing the frequency of importing your options are varied.A DTS package works very well to import the raw data into a 'staging table'. You can even 'clean' the data using a package.You can use a scheduled job to import and clean the data.I would definitely recommend putting the raw data into a separate table […]

2004-04-29

RE: Count of Distinct Records

• by Jason Givens

• SimpleTalk

• Reply

Thanks, I thought I had tried it before but I tried it again.  I must have had "fat fingers" the first time.Thanks again.

2004-04-01

help with the " LTRIM " and split

• by midan1

• SQLServerCentral.com

• Topic

need help with solution after import data into sql tablei have problem with one field !!this field reversedit have character thet contain numberletter (of alphabet)and letter (of Caps)so if i use the command  "REVERSE "all the field will bee reversed included the Numbersmy question is how can i  revers only the letter (of alphabet) ????and […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2004-02-23

2 reads

RE: Stored procedure using dynamic query

• by PCNuttall

• SQLServerCentral.com

• Reply

quote: PC, you are missing out on a lot since dynamic sql used correctly can yield very good results. Although I did not use it in my example, properly parameterized dynamic sql using sp_executesql is sometimes much better than a proc that has tgo handle multiple scenarios. Plans are cached when using sp_executesql and the […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-06-04

RE: Design Question

• by Frank Kalis

• SQLServerCentral.com

• Reply

Hi winash, only thing I can think of is SET ANSI_WARNINGS ON/OFF, but that's something different. I'm pretty sure, I haven't changed settings since I have installed QA. Cheers, Frank

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-06-03

1 reads