SQL Scripts Archives - Page 273 of 318 - SQL Authority with Pinal Dave

SQL SERVER – 2008 – Insert Multiple Records Using One Insert Statement – Use of Row Constructor

July 2, 2008

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

I previously wrote article about SQL SERVER – Insert Multiple Records Using One Insert Statement – Use of UNION ALL. I am glad that in SQL Server 2008 we have new feature which will make our life much more easier. We will be able to insert multiple rows in SQL…

SQL SERVER – Create Check Constraint on Column

June 22, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Error Messages, SQL Scripts

I found one of the Jr. Developer writing trigger for the requirement where he wanted to make sure invalidate data does not enter in table column. I suggested him to write Check Constraint. Check Constraints are very handy to make sure all the data in the table is validated before…

SQL SERVER – Find Current Identity of Table

June 20, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts, SQL Server DBCC

Many times we need to know what is the current identity of the column. I have found one of my developer using aggregated function MAX() to find the current identity. USE AdventureWorks GO SELECT MAX(AddressID) FROM Person.Address GO However, I prefer following DBCC command to figure out current identity. USE AdventureWorks…

SQL SERVER – 2008 – SQL Server Start Time

June 17, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Scripts

I have been playing with SQL Server 2008 recently. There are many new features which SQL Server 2008 have. One of the interesting addition to SQL Server 2008 is system table field which records when SQL Server was started. This field has data type as datetime that is why it…

SQL SERVER – Introduction to SERVERPROPERTY and example

June 16, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

SERVERPROPERTY is very interesting system function. It returns many of the system values. I use it very frequently to get different server values like Server Collation, Server Name etc. Run following script to see all the properties of server. SELECT 'BuildClrVersion' ColumnName, SERVERPROPERTY('BuildClrVersion') ColumnValue UNION ALL SELECT 'Collation', SERVERPROPERTY('Collation') UNION…

SQL SERVER – 2008 – Inline Variable Assignment

June 15, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Scripts

I loved this feature. I have always wanted this feature to be present in SQL Server. Last time when I met developers from Microsoft SQL Server, I had talked about this feature. I think this feature saves some time but make the code more readable. ---- SQL Server 2005 Way…

SQL SERVER – 2008 – Introduction to Policy Management – Enforcing Rules on SQL Server

June 13, 2008

Pinal Dave

SQL Tips and Tricks

Policy Management, SQL Coding Standards, SQL Scripts, SQL Server

I have previous written article about SQL SERVER Database Coding Standards and Guidelines Complete List Download. I just received question from one of the blog reader is there any way we can just prevent violation of company policy. Well Policy Management can come into handy in this scenario.