Provide VBScript code that that outputs the contents of a SQL table into a CSV formatted file called Output.csv. Your code must include the connection string and must use the following SQL criteria: SQL Server Name: DBServerDatabase Name: DBNameSQL User Login: SQLUserSQL User Password: SQLPasswordSQL Table: dbo.Exam (2 fields: FirstName, LastName)

Question: Write a SQL Stored Procedure to create a GUID and add it to a table. Make that GUID an OUTPUT of that Procedure

anjan_maity

 Profile Answers by anjan_maity Questions by anjan_maity

• Aug 7th, 2008

Create a out parameter.Set value with NewId() which return a guid.then insert it into a table.

sutanu_halder

 Profile Answers by sutanu_halder Questions by sutanu_halder

• Dec 14th, 2007

GUIDs are created by the newid() function. If the default of the primary key is set to NewID(),a new GUID is generated for any new row. In addition, the newid() function may be declared within an inse...

Answer Question  Select Best Answer

This is one of the questions I have on my interview exam. It is a take home exam and I have not learned SQL but the employers want to know my know my skills to find answers using any means possible. Question: Review the following SQL code and give a brief explanation SELECT 'AD', B.AccountID,'Change' FROM (SELECT DISTINCT A.sAMAccountName As AccountID from (select AG.sAMAccountName...

ajith007

 Profile Answers by ajith007 Questions by ajith007

• Dec 6th, 2007

Use of distinct, not in keywords make this code altogether complicated. But what I discern from this code 'catch' lies in FULL OUTER JOIN since it retreives all the data including your null values.The union here returns the cross product of query mentioned that includes your null values.

Answer Question  Select Best Answer