全部博文(69)
发布时间:2014-08-19 05:46:59
SQL SERVER (TRANSACT-SQL): PRIMARY KEYSLearn how to create, drop, disable, and enable a primary key in SQL Server (Transact-SQL) with syntax and examples.WHAT IS A PRIMARY KEY IN SQL SERVER?In SQL Server (Transact-SQL), a primary key is a single field or.........【阅读全文】
发布时间:2014-08-18 08:39:22
The SQL Data Types reference sheetThe columns named 8, 9, 10 and 11 indicates SQL Server version data type support where8 = SQL Server 20009 = SQL Server 200510 = SQL Server 200811 = SQL Server 2012DATATYPE.........【阅读全文】
发布时间:2014-08-17 17:45:20
If I want to remove space between characters like: F I L E N A M EI can do like this:Find: ^(?^) space+^(?^)+space, ^(?^) means variable 1Replace as: ^1......【阅读全文】
发布时间:2014-08-17 13:55:03
When I use bcp import data from a flat file into sql server 2012, I got an error:xxxxxxxxx invalid character value for cast specificationI checked the data file, found the date format is like this: mm/dd/yyyy, which is different from SQL server's format yyyy-mm-dd.But I.........【阅读全文】
发布时间:2014-08-11 14:34:22
Microsoft complements its relational database engine, SQL Server, with several add-on services that manage different aspects of enterprise business intelligence and information processing such as data integration, reporting and analysis.Services include the SQL Server Integration Services, SQL Ser.........【阅读全文】