DBCC TRACEON (3605,1204,1222,-1)A brief overview to what those flags do is listed below.
--== This is for SQL 2000. ==-- --== We will create a temporary table to hold the error log detail. ==-- --== Before we create the temporary table, we make sure it does not already exist. ==-- IF OBJECT_ID('tempdb.dbo.ErrorLog') IS Not Null BEGIN DROP TABLE tempdb.dbo.ErrorLog END --== We have checked for the existence of the temporary table and dropped it if it was there. ==-- --== Now, we can create the table called tempdb.dbo.ErrorLog ==-- CREATE TABLE tempdb.dbo.ErrorLog (Id int IDENTITY (1, 1) NOT NULL, ERRORLOG VARCHAR(4000), ContRow int) --== We create a 3 column table to hold the contents of the SQL Server Error log. ==-- --== Then we insert the actual data from the Error log into our newly created table. ==-- INSERT INTO tempdb.dbo.ErrorLog EXEC master.dbo.sp_readerrorlog --== With our table created and populated, we can now use the info inside of it. ==-- BEGIN --== Set a variable to get our instance name. ==-- --== We do this so the email we receive makes more sense. ==-- declare @servername nvarchar(150) set @servername = @@servername --== We set another variable to create a subject line for the email. ==-- declare @mysubject nvarchar(200) set @mysubject = 'Deadlock event notification on server '+@servername+'.' --== Now we will prepare and send the email. Change the email address to suite your environment. ==-- exec master.dbo.xp_sendmail @recipients = 'DBA_Super_Hero@email.com', @subject = @mysubject, @message = 'Deadlock has occurred. View attachment to see the deadlock info', @query = 'select ERRORLOG from tempdb.dbo.ErrorLog where Id >= (select TOP 1 Id from tempdb.dbo.ErrorLog WHERE ERRORLOG Like ''%Deadlock encountered%'' order by Id DESC)', @width = 600, @attach_results = 'True', @no_header = 'True' END --== Clean up our process by dropping our temporary table. ==-- DROP TABLE tempdb.dbo.ErrorLog
--== This is for SQL 2005 and higher. ==-- --== We will create a temporary table to hold the error log detail. ==-- --== Before we create the temporary table, we make sure it does not already exist. ==-- IF OBJECT_ID('tempdb.dbo.ErrorLog') IS Not Null BEGIN DROP TABLE tempdb.dbo.ErrorLog END --== We have checked for the existence of the temporary table and dropped it if it was there. ==-- --== Now, we can create the table called tempdb.dbo.ErrorLog ==-- CREATE TABLE tempdb.dbo.ErrorLog (Id int IDENTITY (1, 1) NOT NULL, logdate DATETIME, procInfo VARCHAR(10), ERRORLOG VARCHAR(MAX)) --== We create a 3 column table to hold the contents of the SQL Server Error log. ==-- --== Then we insert the actual data from the Error log into our newly created table. ==-- INSERT INTO tempdb.dbo.ErrorLog EXEC master.dbo.sp_readerrorlog --== With our table created and populated, we can now use the info inside of it. ==-- BEGIN --== Set a variable to get our instance name. ==-- --== We do this so the email we receive makes more sense. ==-- declare @servername nvarchar(150) set @servername = @@servername --== We set another variable to create a subject line for the email. ==-- declare @mysubject nvarchar(200) set @mysubject = 'Deadlock event notification on server '+@servername+'.' --== Now we will prepare and send the email. Change the email address to suite your environment. ==-- EXEC msdb.dbo.sp_send_dbmail @recipients='DBA_Super_Hero@email.com', @subject = @mysubject, @body = 'Deadlock has occurred. View attachment to see the deadlock info', @query = 'select logdate, procInfo, ERRORLOG from tempdb.dbo.ErrorLog where Id >= (select TOP 1 Id from tempdb.dbo.ErrorLog WHERE ERRORLOG Like ''%Deadlock encountered%'' order by Id DESC)', @query_result_width = 600, @attach_query_result_as_file = 1 END --== Clean up our process by dropping our temporary table. ==-- DROP TABLE tempdb.dbo.ErrorLog
USE [msdb] GO BEGIN TRANSACTION DECLARE @ReturnCode INT SELECT @ReturnCode = 0 IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N'[Uncategorized (Local)]' AND category_class=1) BEGIN EXEC @ReturnCode = msdb.dbo.sp_add_category @class=N'JOB', @type=N'LOCAL', @name=N'[Uncategorized (Local)]' IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback END DECLARE @jobId BINARY(16) EXEC @ReturnCode = msdb.dbo.sp_add_job @job_name=N'Deadlock Job', @enabled=1, @notify_level_eventlog=0, @notify_level_email=0, @notify_level_netsend=0, @notify_level_page=0, @delete_level=0, @description=N'No description available.', @category_name=N'[Uncategorized (Local)]', @owner_login_name=N'sa', @job_id = @jobId OUTPUT IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'Deadlock has occurred.', @step_id=1, @cmdexec_success_code=0, @on_success_action=1, @on_success_step_id=0, @on_fail_action=2, @on_fail_step_id=0, @retry_attempts=0, @retry_interval=0, @os_run_priority=0, @subsystem=N'TSQL', @command=N'--== This is for SQL 2000. ==-- --== We will create a temporary table to hold the error log detail. ==-- --== Before we create the temporary table, we make sure it does not already exist. ==-- IF OBJECT_ID(''tempdb.dbo.ErrorLog'') IS Not Null BEGIN DROP TABLE tempdb.dbo.ErrorLog END --== We have checked for the existence of the temporary table and dropped it if it was there. ==-- --== Now, we can create the table called tempdb.dbo.ErrorLog ==-- CREATE TABLE tempdb.dbo.ErrorLog (Id int IDENTITY (1, 1) NOT NULL, ERRORLOG VARCHAR(4000), ContRow int) --== We create a 3 column table to hold the contents of the SQL Server Error log. ==-- --== Then we insert the actual data from the Error log into our newly created table. ==-- INSERT INTO tempdb.dbo.ErrorLog EXEC master.dbo.sp_readerrorlog --== With our table created and populated, we can now use the info inside of it. ==-- BEGIN --== Set a variable to get our instance name. ==-- --== We do this so the email we receive makes more sense. ==-- declare @servername nvarchar(150) set @servername = @@servername --== We set another variable to create a subject line for the email. ==-- declare @mysubject nvarchar(200) set @mysubject = ''Deadlock event notification on server ''+@servername+''.'' --== Now we will prepare and send the email. Change the email address to suite your environment. ==-- exec master.dbo.xp_sendmail @recipients = ''DBA_Super_Hero@email.com'', @subject = @mysubject, @message = ''Deadlock has occurred. View attachment to see the deadlock info'', @query = ''select ERRORLOG from tempdb.dbo.ErrorLog where Id >= (select TOP 1 Id from tempdb.dbo.ErrorLog WHERE ERRORLOG Like ''''%Deadlock encountered%'''' order by Id DESC)'', @width = 600, @attach_results = ''True'', @no_header = ''True'' END --== Clean up our process by dropping our temporary table. ==-- DROP TABLE tempdb.dbo.ErrorLog ', @database_name=N'master', @flags=0 IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback EXEC @ReturnCode = msdb.dbo.sp_update_job @job_id = @jobId, @start_step_id = 1 IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback EXEC @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @jobId, @server_name = N'(local)' IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback COMMIT TRANSACTION GOTO EndSave QuitWithRollback: IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION EndSave: GO
USE [msdb] GO BEGIN TRANSACTION DECLARE @ReturnCode INT SELECT @ReturnCode = 0 IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N'[Uncategorized (Local)]' AND category_class=1) BEGIN EXEC @ReturnCode = msdb.dbo.sp_add_category @class=N'JOB', @type=N'LOCAL', @name=N'[Uncategorized (Local)]' IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback END DECLARE @jobId BINARY(16) EXEC @ReturnCode = msdb.dbo.sp_add_job @job_name=N'Deadlock Job', @enabled=1, @notify_level_eventlog=0, @notify_level_email=0, @notify_level_netsend=0, @notify_level_page=0, @delete_level=0, @description=N'No description available.', @category_name=N'[Uncategorized (Local)]', @owner_login_name=N'sa', @job_id = @jobId OUTPUT IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'Deadlock has occurred.', @step_id=1, @cmdexec_success_code=0, @on_success_action=1, @on_success_step_id=0, @on_fail_action=2, @on_fail_step_id=0, @retry_attempts=0, @retry_interval=0, @os_run_priority=0, @subsystem=N'TSQL', @command=N'--== This is for SQL 2005 and higher. ==-- --== We will create a temporary table to hold the error log detail. ==-- --== Before we create the temporary table, we make sure it does not already exist. ==-- IF OBJECT_ID(''tempdb.dbo.ErrorLog'') IS Not Null BEGIN DROP TABLE tempdb.dbo.ErrorLog END --== We have checked for the existence of the temporary table and dropped it if it was there. ==-- --== Now, we can create the table called tempdb.dbo.ErrorLog ==-- CREATE TABLE tempdb.dbo.ErrorLog (Id int IDENTITY (1, 1) NOT NULL, logdate DATETIME, procInfo VARCHAR(10), ERRORLOG VARCHAR(MAX)) --== We create a 3 column table to hold the contents of the SQL Server Error log. ==-- --== Then we insert the actual data from the Error log into our newly created table. ==-- INSERT INTO tempdb.dbo.ErrorLog EXEC master.dbo.sp_readerrorlog --== With our table created and populated, we can now use the info inside of it. ==-- BEGIN --== Set a variable to get our instance name. ==-- --== We do this so the email we receive makes more sense. ==-- declare @servername nvarchar(150) set @servername = @@servername --== We set another variable to create a subject line for the email. ==-- declare @mysubject nvarchar(200) set @mysubject = ''Deadlock event notification on server ''+@servername+''.'' --== Now we will prepare and send the email. Change the email address to suite your environment. ==-- EXEC msdb.dbo.sp_send_dbmail @recipients=''DBA_Super_Hero@email.com'', @subject = @mysubject, @body = ''Deadlock has occurred. View attachment to see the deadlock info'', @query = ''select logdate, procInfo, ERRORLOG from tempdb.dbo.ErrorLog where Id >= (select TOP 1 Id from tempdb.dbo.ErrorLog WHERE ERRORLOG Like ''''%Deadlock encountered%'''' order by Id DESC)'', @query_result_width = 600, @attach_query_result_as_file = 1 END --== Clean up our process by dropping our temporary table. ==-- DROP TABLE tempdb.dbo.ErrorLog ', @database_name=N'master', @flags=0 IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback EXEC @ReturnCode = msdb.dbo.sp_update_job @job_id = @jobId, @start_step_id = 1 IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback EXEC @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @jobId, @server_name = N'(local)' IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback COMMIT TRANSACTION GOTO EndSave QuitWithRollback: IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION EndSave: GO
SELECT s.name AS 'schema', ts.name AS TableName,c.name AS column_name, c.column_id,SCHEMA_NAME(t.schema_id) AS DatatypeSchema,t.name AS Datatypename
,t.is_user_defined, t.is_assembly_type
,c.is_nullable, c.max_length, c.PRECISION,c.scale
FROM sys.columns AS c
INNER JOIN sys.types AS t ON c.user_type_id=t.user_type_id
INNER JOIN sys.tables ts ON ts.OBJECT_ID = c.OBJECT_IDINNER JOIN sys.schemas s ON s.schema_id = ts.schema_id
ORDER BY s.name, ts.name, c.column_idSELECT OBJECT_NAME(c.OBJECT_ID) TableName, c.name ColumnName
FROM sys.columns AS c
JOIN sys.types AS t ON c.user_type_id=t.user_type_id
WHERE t.name = 'text' --you can change text to other datatypesORDER BY c.OBJECT_ID;GOSELECTOBJECT_NAME(c.OBJECT_ID) TableName
,c.name AS ColumnName
,SCHEMA_NAME(t.schema_id) AS SchemaName
,t.name AS TypeName
,t.is_user_defined
,t.is_assembly_type
,c.max_length
,c.PRECISION,c.scale
FROM sys.columns AS c
JOIN sys.types AS t ON c.user_type_id=t.user_type_id
ORDER BY c.OBJECT_ID;
Example 1 - Execute master.dbo.xp_fileexist without any parameters
Version - SQL Server 2000 and SQL Server 2005 |
| EXEC Master.dbo.xp_fileexist GO |
| Server: Msg 22027, Level 15, State 1, Line 0 Usage: EXECUTE xp_fileexist <filename> [, <file_exists INT> OUTPUT] |
Example 2 - Execute master.dbo.xp_fileexist with valid file and directory with the results indicating success for both the file and directory, in addition the number of rows is accurately suppressed with the NOCOUNT command
Version - SQL Server 2000 and SQL Server 2005 |
SET NOCOUNT ON
DECLARE @FileName varchar(255) SELECT @FileName='C:\boot.ini' EXEC Master.dbo.xp_fileexist @filename GO |
| File Exists File is a Directory Parent Directory Exists ----------- ------------------- ----------------------- 1 0 1 |
Example 3 - Execute master.dbo.xp_fileexist without a valid file and directory with the results indicating failure for both the file and directory, in addition the number of rows is accurately suppressed with the NOCOUNT command
Version - SQL Server 2000 and SQL Server 2005 |
| SET NOCOUNT ON DECLARE @FileName varchar(255) SELECT @FileName='Z:\bootdoesnotexist.ini' EXEC Master.dbo.xp_fileexist @filename GO |
| File Exists File is a Directory Parent Directory Exists ----------- ------------------- ----------------------- 0 0 0 |
Example 4 - Execute master.dbo.xp_fileexist with a valid file and directory with the results indicating 'File Found', in addition the number of rows is inaccurately suppressed with the NOCOUNT command in SQL Server 2000 and accurately in SQL Server 2005
Version - SQL Server 2000 and SQL Server 2005 |
| SET NOCOUNT ON DECLARE @FileName varchar(255) DECLARE @File_Exists int SELECT @FileName='C:\boot.ini' EXEC Master.dbo.xp_fileexist @FileName, @File_Exists OUT IF @File_Exists = 1 PRINT 'File Found' ELSE PRINT 'File Not Found' GO |
SQL Server 2000 (1 row(s) affected)SQL Server 2005 File Found |
Example 5 - Execute master.dbo.xp_fileexist with an invalid file and directory with the results indicating 'File Not Found', in addition the number of rows is inaccurately suppressed with the NOCOUNT command in SQL Server 2000 and accurately in SQL Server 2005
Version - SQL Server 2000 and SQL Server 2005 |
| SET NOCOUNT ON DECLARE @FileName varchar(255) DECLARE @File_Exists int SELECT @FileName='C:\boot.ini' EXEC Master.dbo.xp_fileexist @FileName, @File_Exists OUT IF @File_Exists = 1 PRINT 'File Found' ELSE PRINT 'File Not Found' GO |
SQL Server 2000 (1 row(s) affected)SQL Server 2005 File Not Found |
Example 6 - Execute master.dbo.xp_fileexist with a valid file and directory with the results stored in a temporary table
Version - SQL Server 2000 and SQL Server 2005 |
| SET NOCOUNT ON DECLARE @FileName varchar(255) CREATE TABLE #File_Results ( File_Exists int, File_is_a_Directory int, Parent_Directory_Exists int ) SELECT @FileName='C:\boot.ini' INSERT INTO #File_Results (File_Exists, file_is_a_directory, parent_directory_exists) EXEC Master.dbo.xp_fileexist @filename SELECT * FROM #File_Results DROP TABLE #File_Results GO |
| File Exists File is a Directory Parent Directory Exists ----------- ------------------- ----------------------- 1 0 1 |
Example 7 - Execute master.dbo.xp_fileexist with an invalid file and directory with the results stored in a temporary table
Version - SQL Server 2000 and SQL Server 2005 |
| SET NOCOUNT ON DECLARE @FileName varchar(255) CREATE TABLE #File_Results ( File_Exists int, File_is_a_Directory int, Parent_Directory_Exists int ) SELECT @FileName='Z:\bootdoesnotexist.ini' INSERT INTO #File_Results (File_Exists, file_is_a_directory, parent_directory_exists) EXEC Master.dbo.xp_fileexist @filename SELECT * FROM #File_Results DROP TABLE #File_Results GO |
| File Exists File is a Directory Parent Directory Exists ----------- ------------------- ----------------------- 0 0 0 |
--===== Return all characters that ISNUMERIC thinks is numeric -- (uses values 0-255 from the undocumented spt_Values table -- instead of a loop from 0-255) SELECT [Ascii Code] = STR(Number), [Ascii Character] = CHAR(Number), [ISNUMERIC Returns] = ISNUMERIC(CHAR(Number)) FROM Master.dbo.spt_Values WHERE Type = 'P' AND Number BETWEEN 0 AND 255 AND ISNUMERIC(CHAR(Number)) = 1That code produces the following list of characters...
Ascii Code Ascii Character ISNUMERIC Returns
---------- --------------- -----------------
9 1
10 1
11 1
12 1
13 1
36 $ 1
43 + 1
44 , 1
45 - 1
46 . 1
48 0 1
49 1 1
50 2 1
51 3 1
52 4 1
53 5 1
54 6 1
55 7 1
56 8 1
57 9 1
128 € 1
160 1
163 £ 1
164 ¤ 1
165 ¥ 1
SELECT * FROM sometable WHERE somecolumn NOT LIKE '%[^0-9]%'... or you can create your own "IsAllDigits" function (this one is an "Inline Table Valued Function" or "iTVF").
CREATE FUNCTION dbo.IsAllDigits /******************************************************************** Purpose: This function will return a 1 if the string parameter contains only numeric digits and will return a 0 in all other cases. Use it in a FROM clause along with CROSS APPLY when used against a table. --Jeff Moden ********************************************************************/ --===== Declare the I/O parameters (@MyString VARCHAR(8000)) RETURNS TABLE AS RETURN ( SELECT CASE WHEN @MyString NOT LIKE '%[^0-9]%' THEN 1 ELSE 0 END AS IsAllDigits )The reason why the formula works is that the "^" means "NOT". So the formula is stating "find everything that's not like something that has something not like a numeric digit." Doing the Boolean math, it means "If everything in the string is a digit from 0 to 9, return a 1".
/*
Microsoft SQL Server Integration Services Script Task
Write scripts using Microsoft Visual C# 2008.
The ScriptMain is the entry point class of the script.
*/
using System;
using System.Data;
using Microsoft.SqlServer.Dts.Runtime;
using System.Windows.Forms;
using Excel = Microsoft.Office.Interop.Excel;
using Microsoft.Office.Interop.Excel;
namespace ST_6dc747ff29cf41c6ac11b7c0bca33d19.csproj
{
[System.AddIn.AddIn("ScriptMain", Version = "1.0", Publisher = "", Description = "")]
public partial class ScriptMain : Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase
{
#region VSTA generated code
enum ScriptResults
{
Success = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success,
Failure = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure
};
#endregion
/*
The execution engine calls this method when the task executes.
To access the object model, use the Dts property. Connections, variables, events,
and logging features are available as members of the Dts property as shown in the following examples.
To reference a variable, call Dts.Variables["MyCaseSensitiveVariableName"].Value;
To post a log entry, call Dts.Log("This is my log text", 999, null);
To fire an event, call Dts.Events.FireInformation(99, "test", "hit the help message", "", 0, true);
To use the connections collection use something like the following:
ConnectionManager cm = Dts.Connections.Add("OLEDB");
cm.ConnectionString = "Data Source=localhost;Initial Catalog=AdventureWorks;Provider=SQLNCLI10;Integrated Security=SSPI;Auto Translate=False;";
Before returning from this method, set the value of Dts.TaskResult to indicate success or failure.
To open Help, press F1.
*/
private static Workbook mWorkBook;
private static Sheets mWorkSheets;
private static Worksheet mWSheet1;
private static Excel.Application oXL;
private static string ErrorMessage = string.Empty;
public void Main()
{
try
{
string sourceExcelPathAndName = @"D:\Excel Import\Excel Import.xls";
string targetCSVPathAndName = @"D:\Excel Import\Excel Import.csv";
string excelSheetName = @"Sheet1";
string columnDelimeter = @"|#|";
int headerRowsToSkip = 0;
if (ConvertExcelToCSV(sourceExcelPathAndName, targetCSVPathAndName, excelSheetName, columnDelimeter, headerRowsToSkip) == true)
{
Dts.TaskResult = (int)ScriptResults.Success;
}
else
{
Dts.TaskResult = (int)ScriptResults.Failure;
}
}
catch (Exception ex)
{
Dts.TaskResult = (int)ScriptResults.Failure;
}
}
public static bool ConvertExcelToCSV(string sourceExcelPathAndName, string targetCSVPathAndName, string excelSheetName, string columnDelimeter, int headerRowsToSkip)
{
try
{
oXL = new Excel.Application();
oXL.Visible = false;
oXL.DisplayAlerts = false;
Excel.Workbooks workbooks = oXL.Workbooks;
mWorkBook = workbooks.Open(sourceExcelPathAndName, 0, false, 5, "", "", false, XlPlatform.xlWindows, "", true, false, 0, true, false, false);
//Get all the sheets in the workbook
mWorkSheets = mWorkBook.Worksheets;
//Get the specified sheet
mWSheet1 = (Worksheet)mWorkSheets.get_Item(excelSheetName);
Excel.Range range = mWSheet1.UsedRange;
//deleting the specified number of rows from the top
Excel.Range rngCurrentRow;
for (int i = 0; i < headerRowsToSkip; i++)
{
rngCurrentRow = range.get_Range("A1", Type.Missing).EntireRow;
rngCurrentRow.Delete(XlDeleteShiftDirection.xlShiftUp);
}
//replacing ENTER with a space
range.Replace("\n", " ", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
//replacing COMMA with the column delimeter
range.Replace(",", columnDelimeter, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
mWorkBook.SaveAs(targetCSVPathAndName, XlFileFormat.xlCSVMSDOS,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive,
Type.Missing, Type.Missing, Type.Missing,
Type.Missing, false);
return true;
}
catch (Exception ex)
{
ErrorMessage = ex.ToString();
return false;
}
finally
{
if (mWSheet1 != null) mWSheet1 = null;
if (mWorkBook != null) mWorkBook.Close(Type.Missing, Type.Missing, Type.Missing);
if (mWorkBook != null) mWorkBook = null;
if (oXL != null) oXL.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(oXL);
if (oXL != null) oXL = null;
GC.WaitForPendingFinalizers();
GC.Collect();
GC.WaitForPendingFinalizers();
GC.Collect();
}
}
}
}
SELECT * FROM [dbo].[ProductInformation] UPDATE [dbo].[ProductInformation] SET [Description] = REPLACE([Description], '|#|', ',') SELECT * FROM [dbo].[ProductInformation]
