Welcome to 2PTTechnology Sign in | Join
in Search
HomeWeb ProjectseCommerceIntranetWindow ProjectsMobileOtherSEOForumsMy AccountAbout UsContact Us
2PTTechnology » Microsoft SQL Server » SQL Scripts

SQL Scripts

New Post
Page 1 of 2 (29 items) 1 2 Next >

Topics

Thread Last Post Replies Views
Cannot resolve the collation conflict between "SQL_Latin1_General...
by twaligora
by twaligora Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CS_AS" and "SQL_Latin1_General_CP1_CI_AS"
10-28-2008 10:16 AM 		- 79
table create date
by twaligora
by twaligora table create date
07-31-2008 10:31 AM 		- 231
Dynamically declare the variables for a table (to use with insert...
by twaligora
by twaligora Dynamically declare the variables for a table (to use with insert/update)
07-25-2008 3:53 PM 		- 242
Search by a date range without the time.
by twaligora
by twaligora Search by a date range without the time.
07-25-2008 10:19 AM 		- 223
Check if date is in the weekend
by admin
by admin Check if date is in the weekend
06-26-2008 4:08 PM 		- 381
Incorrect syntax near the keyword 'COLLATE' SQL 2005
by twaligora
by twaligora Incorrect syntax near the keyword 'COLLATE' SQL 2005
06-06-2008 11:33 AM 		1 921
SQL Exists Condition / Not Exists Condition
by admin
by admin SQL Exists Condition / Not Exists Condition
06-05-2008 4:08 PM 		- 380
search for text in all your stored procedures
by admin
by admin search for text in all your stored procedures
06-04-2008 9:08 PM 		- 577
Remove msrepl_tran_version column with constrant from Database ta...
by admin
by admin Remove msrepl_tran_version column with constrant from Database tables Microsoft Replication
05-06-2008 12:44 PM 		- 646
compare case sensitive data
by twaligora
by twaligora compare case sensitive data
03-28-2008 2:11 PM 		- 235
work around for Divide by zero error encountered SQL
by twaligora
by twaligora work around for Divide by zero error encountered SQL
03-19-2008 3:08 PM 		- 16,994
Create or Add columns to a table dynamically
by twaligora
by twaligora Create or Add columns to a table dynamically
03-10-2008 5:04 PM 		- 956
SQL 2005 Easily Script out entire table columns instead of retypi...
by twaligora
by twaligora SQL 2005 Easily Script out entire table columns instead of retyping them
03-05-2008 11:09 AM 		- 1,668
User or role already exists in the current database (Microsoft SQ...
by Anonymous
by pskobel User or role already exists in the current database (Microsoft SQL Server, Error: 15023)
01-13-2008 12:57 PM 		3 9,878
attach user in SQL 2005 after restore of database
by pskobel
by pskobel attach user in SQL 2005 after restore of database
01-13-2008 12:54 PM 		- 3,099
Change owner of table
by pskobel
by pskobel Change owner of table
11-12-2007 3:22 PM 		- 1,865
Remove non alpha numeric characters from string
by pskobel
by pskobel Remove non alpha numeric characters from string
10-18-2007 12:37 PM 		- 423
Remove non-numeric characters from a string
by pskobel
by pskobel Remove non-numeric characters from a string
10-18-2007 12:33 PM 		- 439
Calculate Daylight savings time, Greenwich Mean Time, Zulu Time S...
by Anonymous
by Anonymous Calculate Daylight savings time, Greenwich Mean Time, Zulu Time SQL Script
07-19-2007 9:58 AM 		4 5,602
return character string of a date for a Month
by pskobel
by pskobel return character string of a date for a Month
05-10-2007 3:19 PM 		- 1,765
New Post Forum Options
Page 1 of 2 (29 items) 1 2 Next >
View as RSS news feed in XML
Powered by Community Server, by Telligent Systems