CHAR constructs a character instead of printing an integer. Preserve byte-code inputs and distinguish an ordinary space from missing output.
SQL SERVER – Import CSV File Into SQL Server Using Bulk Insert – Load Comma Delimited File Into SQL Server
How to import CSV file data into SQL Server with BULK INSERT: create a table, point to the comma delimited file and load every row in a few quick steps.
SQLAuthority News – SQL Joke, SQL Humor, SQL Laugh – Funny Microsoft Quotes
I have received many emails that I should write more post like SQLAuthority News – SQL Joke, SQL Humor, SQL Laugh – Funny Quotes.
SQL SERVER – Simple Example of WHILE Loop with BREAK and CONTINUE
A very simple example of WHILE Loop with BREAK and CONTINUE, plus a Books Online sample that uses a SELECT query in the WHILE condition.
SQL SERVER – FIX : ERROR : Cannot find template file for new query (C:\Program Files\Microsoft SQL Server\90\Tools\ Binn\VSShell\Common7\ IDE\sqlworkbenchprojectitems\Sql\ SQLFile.sql)
Cannot find template file for new query means SSMS lost a small local file. Where it lives, how to restore it, and what to check next.
SQL SERVER – Find All The User Defined Functions (UDF) in a Database
A very simple script that lists all the User Defined Functions in a database, with schema name and type, by reading sys.objects in SQL Server.
Salary Ranges: Match Overlapping Intervals in SQL Server
Match salary ranges using both boundaries of the job and candidate intervals. Define open bounds and test containment, endpoint contact and invalid input.