this question i think you could have found directly from SQL Server Books Online or Google.

bcp AdventureWorks2008R2..MyTestFormatFiles format nul -c -t, -x -f myTestFormatFiles.Xml -T

http://msdn.microsoft.com/en-us/library/aa174646(SQL.80).aspx

there are two functions you can use to check the length of a string :

LEN(SomeField)

--or

DATALENGTH(SomeField)

both return integer values. I believe that your check constraint would have to use either...

Scott awesome job posting the table and data; it makes it so easy for me to test with!

Thank you!

someone poke holes in my calculations, but i keep getting 20 days...

Your response is very misleading...you said you were building an application in c#; that application is a Windows Application right? Based on that, I inferred you had some familiarity with...

if there are two tables, aliased W and T, i think it should look like this:

UPDATE W

SET

W.TableNumber = T.TableNumber,

W.LineNumber = T.LineNumber,

.....

UnitNumber = T.UnitNumber

FROM [LINKED SERVER].DATABASE.dbo.TABLE1 AS W,

[LINKEDSERVER].DATABASE.dbo.temporaryTABLE AS T

WHERE W.IdentityID...

every dataTable and dataSet in .NET has the ability to .ReadXML and .WriteXML.

you can add a .xsd DataSet to your project, and drag and drop an one or more...

ahh ok, then i think you can use dynamic sql to add the linked server.

you might want to drop and recreate each time, or use a if not exists(select *...

Richard maybe something like this:

the proc sp_tables_ex in a try...catch, if it fails to find the linked server?

i tested it with both a valid and invalid linked server name, and...

CREATE PROCEDURE WHATEVER WITH ENCRYPTION.....

but encryption only goes so far....SQL has to be able to decrypt it to use it, right? you can make it harder on them, but it...

the bad news: anyone with sysadmin privileges cannot be prevented from reviewing your database, and even if you disabled Windows logins, since he has physical control, he could add himself...

wrong tool for the job.

reading a web page, entering username and password /submit and browsing to other pages requires some interaction type activities.

much much better to create an application in...

you had it almost perfect, just needed to remove the stuff between CASE and WHEN

CREATE TABLE EmployeeResult

(ERId INT IDENTITY(1,1),

QuestionNo TINYINT,

EmpAns CHAR,

RealAns CHAR,

Comparison AS

CASE

...

excelent tomas glad it's working for you;

performance wise, it it the same as the inline calculation you tested against?

again, if you explain why you want to open IE thru sql and not other methods we could help you better. detailed info gets detailed answers...vague statements gets vague answers.

CLR...

i formatted your SQL and converted it to use some CTE's;

look at the final sql and tell us what is not working: how is the data incorrect?

WITH t2 AS

...