Hi Friends this blog is just a collection of SQL quires i required during my scripting am just trying to create a collection of what i have got from the net and i don't claim that all the content displayed belongs to me...
Thanks
Popular posts
-
Introduction In this article I am going to explain how to use Subqueries in SQL. A select statement known as subquery if it is codded w...
-
Introduction If your SQL query is not returning the result-set in the order you are expecting, this article may be helpful to fix th...
-
Table : People Name Peter Paul Mary DECLARE @ Names VARCHAR ( 8000 ) SELECT @ Names = COALESCE (@ Names + ', ' , ...
-
Introduction If you want unique value in any specific column use UNIQUE constraints. UNIQUE constraints does not allow any duplicate ...
-
The CHARINDEX string function returns the starting position of the specified expression in a character string. It accepts three paramete...
-
Definition and Usage The DATEDIFF() function returns the time between two dates. Syntax DATEDIFF(datepart,startdate,enddate) Wh...
-
DECLARE @ Reviews TABLE ( ReviewID INT , ReviewDate DATETIME ) DECLARE @ Reviewers TABLE ( ReviewerID INT ,...
-
SQL Server 2008 introduced 4 new data types associated with the date and time, namely, the DATE, TIME, DATETIME2 and DATETIMEOFFSET data t...
-
SQL Server 2012 introduces a new category of built-in scalar functions, the logical functions, which as the name implies, performs logical...
-
Standard Date Formats Date Format Standard SQL Statement Sample Output Mon DD YYYY 1 HH:MIAM (or PM) Default SELECT CONVERT(VAR...
My MSSQL Search Collections Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates
0 comments:
Post a Comment