sql - Tinyint vs Bit sql - Tinyint vs Bit current community your communities Sign up or log in to customize your list. more stack exchange communities Stack Exchange
For performance and reliability reasons, it is strongly recommended that you use a client-server database engine for the deployment of data driven Web applications that require high-demand access from more than approximately 10 concurrent users. Although ADO works with any OLE DB compliant data source, it has been extensively tested and is designed to work with client server databases such as SQL Server. ASP supports shared file databases (Access or FoxPro) as valid data sources. Although some ASP example code use a shared file database, it is recommended that these types of database engines be used only for development purposes or limited deployment scenarios. Accessing Data with ADO Accessing Data with ADO
Peter DeBetta's SQL Programming Blog : T-SQL UrlEncode Peter DeBetta's SQL Programming Blog : T-SQL UrlEncode I was perusing the newsgroups when I came across a request in the microsoft.public.sqlserver.clr newsgroup to see if there was a way to use System.Web.HttpUtility.UrlEncode in T-SQL. I know using the CLR is an option, but I decided to write a T-SQL equivalent. I reflected the code to figure out the exact rules for UrlEncoding. Then, I discovered much to my delight, a new system function in SQL Server 2005 that converts a string to its hexadecimal equivalent as a string– sys.fn_varbintohexstr.
An SQL text by Erland Sommarskog, SQL Server MVP. Latest revision: 2011-06-23. An earlier version of this article is also available in German. Translations provided by SQL Server MVP Frank Kalis. The curse and blessings of dynamic SQL The curse and blessings of dynamic SQL
SSMS Tools Pack by Mladen Prajdić Features SSMS Tools Pack Features SSMS Tools Pack Features
How to export data from SQL Server 2008.2010 in DML (SQL script) Explore our sites Stack Exchange sign up log in tour help careers 2.0 Stack Overflow Ask Question Take the 2-minute tour × How to export data from SQL Server 2008.2010 in DML (SQL script)
query - How to read a Text file using T-SQL query - How to read a Text file using T-SQL Explore our sites Stack Exchange sign up log in tour help careers 2.0
sql server - T-SQL: Opposite to string concatenation - how to split string into multiple records You can also achieve this effect using XML, as seen here, which removes the limitation of the answers provided which all seem to include recursion in some fashion. The particular use I've made here allows for up to a 32-character delimiter, but that could be increased however large it needs to be. CREATE FUNCTION [dbo].[Split] (@sep VARCHAR(32), @s VARCHAR(MAX)) RETURNS @t TABLE ( val VARCHAR(MAX) ) AS BEGIN DECLARE @xml XML SET @XML = N'<root><r>' + REPLACE(@s, @sep, '</r><r>') + '</r></root>' INSERT INTO @t(val) SELECT r.value('.' sql server - T-SQL: Opposite to string concatenation - how to split string into multiple records
Peter DeBetta's SQL Programming Blog : T-SQL UrlDecode
INSERT (Transact-SQL) INSERT (Transact-SQL) WITH <common_table_expression> Specifies the temporary named result set, also known as common table expression, defined within the scope of the INSERT statement. The result set is derived from a SELECT statement. For more information, see WITH common_table_expression (Transact-SQL). TOP (expression) [ PERCENT ]
SELECT @local_variable (Transact-SQL) SELECT @local_variable (Transact-SQL) Specifies that the specified local variable that is created by using DECLARE @local_variable should be set to the specified expression. For assigning variables, we recommend that you use SET @local_variable instead of SELECT @local_variable. For more information, see SET @local_variable. Transact-SQL Syntax Conventions
Storing Variable Values in Temporary Array or Temporary List SQL Server does not support arrays or a dynamic length storage mechanism like list. Absolutely there are some clever workarounds and few extra-ordinary solutions but everybody can;t come up with such solution. Additionally, sometime the requirements are very simple that doing extraordinary coding is not required. Here is the simple case.
Explore our sites Stack Exchange sign up log in tour help careers 2.0 Stack Overflow Declare a variable list in SQL Server stored procedure
Database Programming: TOP Without ORDER BY? - Ward Pond's SQL Server blog Egad, a technical post! And after I'd already said goodbye for the month. A long time ago, a friend taught me that expectations are small murders. What does that make plans?
Slow in the Application, Fast in SSMS? An SQL text by Erland Sommarskog, SQL Server MVP. Last revision: 2013-08-30. This article is also available in Russian, translated by Dima Piliugin.
New in SQL Server 2008 is support for large user-defined types (UDTs). We’re going to build a Common Language Runtime (CLR) UDT that allows us to store, compress, and decompress binary data (up to 2GB in size) inside SQL Server 2008. This technique works only in SQL Server 2008 because only SQL Server 2008 allows CLR UDTs larger than 8KB. The UDT we’ll build, called VarBinaryComp, accepts both uncompressed data (which it will compress before storing) and compressed data as input. It also has properties to determine the length of the compressed and uncompressed data. Using Large CLR UDTs in SQL Server 2008 | Development content from SQL Server Pro
MD5 Hash SQL Server Extended Stored Procedure
Fix : Error 1205 : Transaction (Process ID) was deadlocked on resources with another process and has been chosen as the deadlock victim. Rerun the transaction
DB2 Universal Database
sql server - 900 byte index size limit in character length
SQL Server CREATE TABLE syntax diagrams
sql - Are there any disadvantages to always using nvarchar(MAX)
Maximum Capacity Specifications for SQL Server
Indexing for Sort Performance | Data Access content from SQL Server Pro
Clustered Index and Non-Clustered Index in SQL Server
Immediate deadlock notifications without changing existing code
SQL String User Function Workbench: part 2
TSQL String Array Workbench
SQL Server Backup, Integrity Check, Index and Statistics Maintenance
SourceForge.net: SQL-Viewer - Project Web Hosting - Open Source Software
SourceForge.net: Remote MySQL Viewer - Project Web Hosting - Open Source Software
BasicQuery SourceForge Project Homepage
T-SQL Developer project home page
SQL Buddy Sourceforge Site
Transact-SQL Analyzer | Free Development software downloads at SourceForge
c# - SQL: Update a row and returning a column value with 1 query
LINQ to XSD - Home
URLEncode
User Defined Functions in Microsoft SQL Server 2000
Export data from SQL Server to MS Access
Statistics in SQL Server
Named Pipe in ADODB Connection - Xtreme Visual Basic Talk
How to Connect to a SQL Server Named Instance
Timeout error when trying to delete records
Overview of the SQL Server Browser service
Andy Leonard : Quick Database Connectivity Testing
Named Pipes Provider, error: 40 - Could not open a connection to SQL Server - SQL Protocols
sql server - How to get a list of users for all instance's databases
SQL Server Named Pipe Connection...
asp classic - Server-side Javascript in production fails to open connection to a named instance of SQL2008
How To Set the SQL Server Network Library in an ADO Connection String
Aaron Bertrand : Bad habits to kick : choosing the wrong data type
Chastised for recommending use of bit data type
CONQUEST SOFTWARE SOLUTIONS - Tools for Oracle development, database administration, SQL and PL/SQL formatting, analysis and flowcharting, oracle development tools, pl/sql gui, plsql ide, pl/sql tools, pl/sql ide, pl/sql environment, pl/sql development, p
SQL Developers - Mimer SQL-2003 Validator
Subqueries with NOT EXISTS
sys.objects (Transact-SQL)
Meta Data Functions
IF...ELSE
sql server - How do you perform an IF...THEN in an SQL SELECT
CAST and CONVERT
sql server 2000 - SQL2000 safely cast a VARCHAR(256) to INT
datetime (Transact-SQL)
int, bigint, smallint, and tinyint
decimal and numeric
float and real
Data Types
ntext, text, and image