Library code snippets tagged with sql server

• Bulk Insert from Flat File Using Transact-SQL

  by M M Harinath

  Importing Data from Text File using Transact-SQL is not a tough task, we can import data from Flat File in just 3 steps. sql, sql server

• Randomly Sorting Records

  by James Crowley

  Here's now to randomly sort records in SQL Server 2000 - so you can potentially select say 10 random items from a table. sql server

• Calculate Diskspace Used by a Table or Database

  by James Crowley

  This short snippet shows how to discover how large a particular table or an entire database is in SQL Server. sql server

• Resizing images retrieved from SQL server

  by Simon Soanes

  A neat way of fetching an image stored in SQL Server and resizing it before save/sending it anywhere. asp.net, sql, sql server

• Display SQL Server table data in a browser

  by Edward Tanguay

  Just supply your database connection string and this code will give you a radio button list of all your SQL Server tables and will show their fields. asp.net, sql, sql server

• Update MSMQ from SQL

  by Bruce Johnson

  Describes how to post a message into MSMQ from within a SQL procedure sql server, sql

• T-SQL implementation of SKIPJACK

  by David Janecka

  A T-SQL implementation of the crypt algorith SKIPJACK as a user function for MS-SQL 2000 sql server, sql

• Access, VB and SQL Server wildcard characters

  by James Crowley

  Important differences between Access, VB and SQL Server wildcard characters sql, sql server