Microsoft SQL Server and SQL Server Management Studio
A category to select articles regarding Microsoft SQL Server and SQL Server Management Studio 2012.
In order to divide two integer type fields in SQL Server you will have to apply a type cast before applying the mathematical operation.
Else you will receive zero (0) as a result whenever one of the numbers is not null, which is obviously not what we want.
- Hits: 9224
If you are confronted with the inconvenience of having to truncate all tables in a database in MS SQL Server, the following T-SQL might help.
It is important to use the type varChar for the name @tab_name since its content is concatenated with some SQL command to truncate tables.
- Hits: 9011
Importing text files into tables in SQL Server database schemas can be done using different methods.
One method using SQL Server specific SQL is shown below.
If you want to use tab delimited source files you can type in the delimiter into FIELDDELIMITER using the tabulator key in SQL Server Management Studio.
BULK INSERT CSVTest FROM 'c:\csvtest.txt' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' ) GO
- Hits: 9221
Page 1 of 2