using …

Pure C#

Archive for the ‘Transact-SQL’ Category

TSQL Split String

Posted by esersahin on 30/04/2012


http://stackoverflow.com/questions/314824/t-sql-opposite-to-string-concatenation-how-to-split-string-into-multiple-reco

http://stackoverflow.com/questions/8517816/t-sql-split-word-into-characters

http://social.msdn.microsoft.com/Forums/en/transactsql/thread/08655b4a-3ae6-4be4-b8e4-a98877f1f74d

http://pavelpawlowski.wordpress.com/2010/10/06/fastest-csv-strings-splitting-using-clr-t-sql-vs-clr-revisited/

http://blog.nhaslam.com/tag/t-sql/

http://www.pawlowski.cz/tag/string-splitting/

http://social.msdn.microsoft.com/Forums/en/transactsql/thread/08655b4a-3ae6-4be4-b8e4-a98877f1f74d

Posted in split, Transact-SQL | Leave a Comment »

Changing the table reserved size

Posted by esersahin on 27/04/2012


http://www.sqlservercentral.com/Forums/Topic339269-5-2.aspx#bm339345

Posted in DBCC, DBREINDEX, INDEXDEFRAG, Sql Server, Sql Server 2008 R2, Transact-SQL | Leave a Comment »

User defined function (UDFs) That Return a Table

Posted by esersahin on 05/07/2011


http://www.java2s.com/Code/SQLServer/Store-Procedure-Function/UsedefinedfunctionUDFsThatReturnaTable.htm

Posted in Functions, Transact-SQL | Leave a Comment »

Table join with data returned from function

Posted by esersahin on 05/07/2011


http://www.java2s.com/Code/SQLServer/Store-Procedure-Function/Tablejoinwithdatareturnedfromfunction.htm

Posted in Functions, Transact-SQL | Leave a Comment »

SQL Server Transact-SQL (SSQA.net) – Random Password Generator

Posted by esersahin on 17/12/2010


http://sqlserver-qa.net/blogs/t-sql/archive/2007/11/20/2805.aspx

Posted in Transact-SQL | Leave a Comment »

SQL Server 2005 – Temp tables & Collation

Posted by esersahin on 14/09/2010


http://onlytalkingsense.wordpress.com/2006/08/17/temp-tables-collation/

Posted in SQL Collation, Transact-SQL | Leave a Comment »

Create a date with T-SQL

Posted by esersahin on 22/06/2010


http://stackoverflow.com/questions/266924/create-a-date-with-t-sql

Posted in DateTime, Transact-SQL | Leave a Comment »

T-SQL’s Datetime Data Type

Posted by esersahin on 22/06/2010


http://www.sqlmag.com/article/tsql3/t-sql-s-datetime-data-type.aspx

Posted in DateTime, Transact-SQL | Leave a Comment »

SQL TIP: Auto Increment in an UPDATE statement.

Posted by esersahin on 11/04/2010


http://haacked.com/archive/2004/02/28/sql-auto-increment.aspx

Posted in AutoIncrement, SQL, Sql Server, Transact-SQL, Update | Leave a Comment »

SQL Server 2005 : Verify table already exists

Posted by esersahin on 21/10/2009


http://gchandra.wordpress.com/2007/12/04/sql-server-2005-verify-table-already-exists/

Posted in Sql Server, Table, Transact-SQL | Leave a Comment »