B.NET(bdotnet.in)

Hi SQL SERVER 2005 introduced new function NEWSEQUENTIALID () CREATE TABLE myGUIDTable (myCol uniqueidentifier DEFAULT NEWSEQUENTIALID())

Hi Less records it’s nothing for SQL SERVER you can access directly underlying table. As queries become more complex, temporary tables are used more and more. While temporary table may sometimes be unavoidable, they can often be sidestepped by using derived tables instead. In brief, a derived table is...

Has anyone been able to use the BULK INSERT command successfully to import a file that has Carriage Return (CHAR(13) I think) as row terminator ? The BULK INSERT documentation allows only for Carriage Return + Line Feed = NewLine, i.e. \n as Row Terminator and other printable characters, but not the...