-
All Categories
-
- Recent Posts
Recent Posts
Recent CommentsRecent Comments
- NuSkin Training on Converting Single-File Web Forms Pages to Code-Behind Pages
- free ipod on how to get MAC address using C#
- Breast Cancer Articles on Integrate Search Into Your Site With ASP.NET
- Nikken Training on
- Breast Cancer on Windows 7 : C# Error:’Microsoft.Jet.OLEDB.4.0′ provider is not registered on the local machine
Category Archives: Database
SQL Server decimal Scale and Precision
Example: 102.786 Here, Precision =6=number of digits in a number Scale =786=the number of digits to the right of the decimal point Sql Server Decimal Data Type decimal(5, 3) Precision:5 Scale : 3 Ref: http://www.dotnetdawgs.com/post/SQL-Server-decimal-Scale-and-Precision.aspx
Posted in data types
474 Comments
Enable saving of changes that require table to be re-created SQL server 2008
When working with SQL Server Management studio, if you use the Design view of a table and attempt to change a table then it shows this message “Enable saving of changes that require table to be re-created SQL server 2008″. … Continue reading
MS Sql server: How to do multiple rows insert ?
Recently I have faced a problem when insert multiple row insert at single call. After first row insert then problem arise from second row insert. After goggling I have found a solution : it need to clear parameter after each … Continue reading
Posted in C#, MS SQL
846 Comments
How to DataTable export to Excel in asp.net
It is a very common question is asp.net forum and other forum that how to export DataTable to excel in asp.net.There are various ways to export data to excel, such as: 1. Write As XML with .XLS extensions 2. … Continue reading
Posted in ASP.NET, C#, Database, datatable
847 Comments