Tuesday, March 11, 2008

SQL Server Articles

Please visit my new Web Site WWW.Codedisplay.com

** Syntax of Shrinking SQL Server database mdf and log file

** Error: The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator

** Set a database to read only mode using SQL Server 2005 / 2008

** Kick expire close all user connection from Sql Server 2005 / 2008 Database

** Creating RSS feed using Asp.Net 2.0 / 3.5

** Display Images in GridView from Sql Server Database Table Using Asp.net C#

** Save Images into Sql Server Database Table using asp.net FileUpload Control

** Javascript to get CheckBoxList value

** The syntax of SQL Server Cursor

** SQL Server 2008 Error: Saving changes is not permitted

** How to pass SP parameters into Dynamic SQL

** Write & Execute Dynamic SQL in SQL Server Stored Procedure

** Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints

** How to delete multiple rows in a GridView using Asp.net

** Add/Modify/Resize/Change/Delete/Drop/Rename MS SQL Server Table Column using T-SQL

** Making or creating comma separated value list in a single line using SQL SP or UDF

** Login failed for user: The user is not associated with a trusted SQL Server connection

** Delete or remove duplicate rows from SQL Server table using TSQL

** How to write TSQL for inner/left/right/full join in update query

** How to Import Excel Spreadsheet Data into SQL Server Database using ASP.NET C#

** List of Built-in String Functions in SQL Server

** DATEPART, DATEADD, DATEDIFF SQL Server Standard Datetime Function

** For each Category or Group Select FIRST N rows, TOP N rows, LAST N rows, BOTTOM N rows, Random data

** SQL Server Date Time Format

** How to configure SQL Server 2005 to allow remote connections

** A list of Keyboard Shortcuts in SQL Query Analyzer

** How to read data from sql server stored procedure using asp.net


Want to say something?

Want To Search More?
Google Search on Internet
Subscribe RSS Subscribe RSS
Article Categories
  • Asp.net
  • Gridview
  • Javascript
  • AJAX
  • Sql server
  • XML
  • CSS
  • Free Web Site Templates
  • Free Desktop Wallpapers
  • TopOfBlogs
    Free ASP.NET articles,C#.NET,VB.NET tutorials and Examples,Ajax,SQL Server,Javascript,Jquery,XML,GridView Articles and code examples -- by Shawpnendu Bikash