Four ways to elevate team efficiency and code quality

IDC have reported that ‘the shortage of full-tim...

Datefirst

Week Starts On Saturday?

A function that emulates SET DATEFIRST 6 within a function for finding relevant date information.

SQLXMLBulkLoad C# Issue on Insert :: URGENT HELP!

I have a large dataset (names; in this context) of more than 50000 records which i wanted to dump into SQL Server using SQLXMLBulkLoad. I use C# and here is how i implemented:// Initialize OLEDB Connection for SQLXML Bulk LoadSQLXMLBulkLoad3Class bl = new SQLXMLBulkLoad3Class();bl.ConnectionString = ConUtil.GetBulkXMLConString();//bl.KeepIdentity = true; bl.BulkLoad = true; //bl.Transaction = true;bl.ErrorLogFile = "BulkImport.log";bl.ForceTableLock […]

RE: Suppress messages when executing a procedure

Stefan,which messages do you mean? Can you post an example?

RE: Return row number without using IDENTITY

OK, MS is out of date; using a subquery is faster. Like this: Select t.tname, t.tid, ( Select count(t1.tid) From #test t1 where t1.tName < t.tName--This is where you signify the rank order ) NameRank From #test t ----------------Test Data------------------ if object_ID('tempdb..#test') is not null drop table #test create table #test (Tid int identity, tname […]