There are cases we want to execute a query includes a WHERE clause which must look up in a subquery and join tables is not prefferable . Fi...
Read More
Showing posts with label SQL Server. Show all posts
Showing posts with label SQL Server. Show all posts
Rebuild all Indexes in SQL SERVER
SQL Server 2000 Rebuild all indexes with keeping the default fill factor for each index USE [DATABASE_NAME] EXEC sp_MSforeachtable @comm...
Read More
Convert Integer to String in SQL Server
This is how to convert an integer to string in SQL SERVER. Let's suppose we want to present the year as a string SELECT CAST(dbo.Emplo...
Read More
SQL Server Collations
Below table contains the details of SQL Server Collations: Albanian_BIN Albanian, binary sort Albanian_BIN2 Albanian, binary code point ...
Read More
Subscribe to:
Posts (Atom)