... but if you REALLY wanted to emulate a char(1) field as you have done, you could just create your table like:

CREATE TABLE #MyTable

(

MyBooleanField char(1)...

No need to emulate... just use the BIT datatype. It is a boolean.

pedro.ribeiro (4/23/2009)

---

It's What about the:

"Set nocount on" does this instructuction affects the error count (@@error) inside the stored procedure while it is executing?

Or the Set nocount on, only affects the...

yulichka (4/23/2009)

---

I have 5 csv files that I need to insert to the table. They contain 375000 records in total. Is there solution if one of the records are bad...

b_boy (4/23/2009)

---

I have scenario to update a col A, with col B.

If col A has a record like '%A' and col B is blank, then update col B with col...

You didn't provide enough information.

You need to add 375,000 rows, and you're concerned about having enough space.

So, you need to determine how much space each row will take in that...

anjana.maganti (4/23/2009)

---

Could you please help how to get First part of the (or 15 char length) from the @EducationCodeDesc paramenter in the procedure itself?

i mena like using any fuction..

Anyways you...

anjana.maganti (4/23/2009)

---

Hi I have an SP like following..... I am getting an error like 'String or binary data would be truncated' when am trying to insert a value in the...

I don't do a lot of VBScript programming, but from what I see:

1. your main routine never calls the DbaseUpd subroutine. I think before the conn.Execute line, you need a...

Ahh, didn't consider double-posting. I thought that I had posted that reply, but then I second-guessed myself and figured that I just didn't click the post button...

Try this:

declare @testdate varchar(50), @realdate datetime

set @testdate = 'Monday, January 28, 2008'

set @realdate = SUBSTRING(@testdate, CharIndex(', ', @testdate)+2, 50)

select @testdate, @realdate

Try this:

declare @testdate varchar(50), @realdate datetime

set @testdate = 'Monday, January 28, 2008'

set @realdate = SUBSTRING(@testdate, CharIndex(', ', @testdate)+2, 50)

select @testdate, @realdate

Dizzy (4/23/2009)

---

I do have some numbers that are quantities rather than values that I would prefer to show to 1dp rather than the 2dp that MONEY gives. I want...

Does the whole procedure get executed only on the first day of the month, or is there some part of it that only gets executed on the first day of...

You are looking for the system view sys.all_sql_modules. Specifically the definition column.