it's they way a default constraint works...i think you are misunderstanding it.

a default constraint DOES NOT replace nulls with the default value...it puts the default value in if the column...

is the length of the fields with preceding zeros all the same? for example are the 6 characters? '000008'?

you can change the column to a varchar, and then update...

not directly, no.

each column has to be referenced in the update statement, but you can use the schema tables to generate the SQL statement for you.

you were a little loose...

here's another way to do the same thing: ColdCoffee thank you for the setup!:

DECLARE @PhoneNumbers TABLE

(

ID INT IDENTITY(1,1),

TEL1 BIGINT,

TEL2 BIGINT,

TEL3...

the technology already exists....

I know the feeling...you put a lot of hard work and time into designing the database objects, and you don't want anyone to look at them because they could infer...

another way is to connect via the Dedicated Administrative Connection (DAC)

a perfect example would be you removed builtin\administrators and then forgot the sa password...which was the only sysadmin on your...

I had a similar issue where a specific login i created for testing would show up first when i selected a server...so i'd have to change it over and over...

nice explanation, Craig;

Yep asking...

there's a an project on codeproject.com that has a decent example of how to bind a report to a dynamic dataset; by coincidence it's also in C# as well;

basically, it...

allin1 (9/17/2010)

---

As a part of PCI compliance lets say we encrypted all the 16 digit a/c numbers and socials. ANd with in the employee team if we are trying to...

whetehr you beleive it or not, it's returning more than one value:

if i put RMP.PeriodID =8 instead of PeriodID=8 Then it says an error that sub query returned more than...

SQL chooses the fastest way to access the data, and if no ORDER BY is used, returns it in that order;

So if there are no joins to other tables, then...

Richard it's fairly straightforward, but involves a combination of techniques.

if it's a file, you need to use bcp or bulk insert to get the text.

you need to use a split...