Blogs about: Sql Query

Featured Blog

Drop Unique Constraint in MySQL

If you would like to drop a unique constraint from your table in MySQL, there is a very simple way to do it. Thanks to how to drop unique constraint, you can do so as well. The trick is to know that y… more →

Code Ghar

SQLAuthority News - 700 Articles and Author Updates — 1 comment

pinaldave wrote 3 weeks ago: It is always interested to write article when reached at milestone. I start to receive many emails a … more →

Tags: technology, SQL Server, SQL, dba, Database, SQL Tips and Tricks, SQL Authority, SQLAuthority News, T-SQL

SQLAuthority News - SharePoint - Steps To Create A Custom WebPart - Deploy It SharePoint Site — 7 comments

pinaldave wrote 4 weeks ago: SharePoint is one interesting software from Microsoft. My outsourcing location unit is working on on … more →

Tags: Author Pinal, Software development, SQL, SQL Authority, SQL Documentation, SQL Server, SQL Tips and Tricks, SQLAuthority, SQLAuthority News

SQL Server - Error : Fix : SharePoint Stop Working After Changing Server (Computer) Name — 1 comment

pinaldave wrote 4 weeks ago: If Microsoft Office SharePoint Server (MOSS) and your database (MS SQL Server) are running together … more →

Tags: Author Pinal, Software development, SQL, SQL Authority, SQL Documentation, SQL Error Messages, SQL Server, SQL Tips and Tricks, T-SQL

SQL SERVER - 2008 - Creating Primary Key, Foreign Key and Default Constraint — 3 comments

pinaldave wrote 1 month ago: Primary key, Foreign Key and Default constraint are the 3 main constraints that need to be considere … more →

Tags: technology, SQL Server, SQL, SQL Constraint and Keys, SQL Tips and Tricks, SQL Authority, Author Pinal, T-SQL, SQL Scripts

SQL SERVER - 2008 - Creating Full Text Catalog and Full Text Search — 7 comments

pinaldave wrote 1 month ago: Full Text Index helps to perform complex queries against character data.  These queries can include … more →

Tags: Author Pinal, SQL, SQL Authority, SQL Index, SQL Scripts, SQL Server, SQL Tips and Tricks, sqlcmd, T-SQL

SQLAuthirty Author Visit - SQL SERVER - User Group Meeting - Ahmedabad - August 30, 2008 — 3 comments

pinaldave wrote 1 month ago: I always enjoy participating in SQL Server User Group. We had recent meeting of Ahmedabad User Group … more →

Tags: Author Pinal, SQL, SQL Authority, SQL MVP, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL User Group, SQLAuthority Visit

SQLAuthority Author Visit - Microsoft Student Partner Conference — 4 comments

pinaldave wrote 1 month ago: The Microsoft Student Partner Program is a worldwide initiative to sponsor students who are interest … more →

Tags: technology, SQL Server, SQL, dba, Database, SQL Tips and Tricks, Software development, SQL Authority, T-SQL

SQL SERVER - 2008 - Introduction to Filtered Index - Improve performance with Filtered Index

pinaldave wrote 1 month ago: Filtered Index is a new feature in SQL SERVER 2008. Filtered Index is used to index a portion of row … more →

Tags: technology, SQL Server, SQL Performance, SQL, SQL Tips and Tricks, SQL Index, SQL Authority, Author Pinal, T-SQL

SQL SERVER - 2008 - Introduction to Table-Valued Parameters with Example

pinaldave wrote 1 month ago: Table-Valued Parameters is a new feature introduced in SQL SERVER 2008. In earlier versions of SQL S … more →

Tags: Author Pinal, SQL, SQL Authority, SQL Performance, SQL Scripts, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, sqlcmd

SQL SERVER - FIX : ERROR : Could Not Connect to SQL Server - TDSSNIClient initialization failed with error 0x7e, status code 0x60

pinaldave wrote 1 month ago: This is a very common error faced by so many people and I get lots of questions regarding this error … more →

Tags: Author Pinal, SQL, SQL Authority, SQL Error Messages, SQL Server, SQL Tips and Tricks, T-SQL, technology

SQL SERVER - Few Useful DateTime Functions to Find Specific Dates — 9 comments

pinaldave wrote 1 month ago: Recently I have recieved email from Vivek Jamwal, which contains many useful SQL Server Date functio … more →

Tags: Author Pinal, SQL, SQL Authority, SQL DateTime, SQL Function, SQL Scripts, SQL Server, SQL Tips and Tricks, T-SQL

SQL SERVER - 2008 - Introduction to Merge Statement - One Statement for INSERT, UPDATE, DELETE — 1 comment

pinaldave wrote 1 month ago: MERGE is a new feature that provides an efficient way to perform multiple DML operations. In previou … more →

Tags: Author Pinal, SQL, SQL Authority, SQL Joins, SQL Performance, SQL Scripts, SQL Server, SQL Tips and Tricks, T-SQL

SQLAuthority News - Download SQL Server 2008 Report Builder 2.0 RC1 — 3 comments

pinaldave wrote 1 month ago: Microsoft SQL Server 2008 Reporting Services Report Builder 2.0 supports the full capabilities of SQ … more →

Tags: Data Warehousing, Database, dba, SQL, SQL Add-On, SQL Authority, SQL Download, SQL Server, SQL Tips and Tricks

SQLAuthority News - SQL Server Express 2008 Downloads — 3 comments

pinaldave wrote 1 month ago: Microsoft SQL Server 2008 Express with Tools Microsoft SQL Server 2008 Express with Tools (SQL Serve … more →

Tags: Software development, SQL, SQL Add-On, SQL Authority, SQL Download, SQL Server, SQL Tips and Tricks, SQLAuthority News, T-SQL

SQL SERVER - How to Rename a Column Name or Table Name — 10 comments

pinaldave wrote 1 month ago: I often get request from blog reader for T-SQL script to rename database table column name or rename … more →

Tags: technology, SQL Server, SQL, SQL Stored Procedure, SQL Tips and Tricks, SQL Authority, Author Pinal, T-SQL, SQL Scripts

SQLAuthority News - Ahmedabad SQL Server User Group Meeting - August 2008 — 3 comments

pinaldave wrote 1 month ago: I will be attending Ahmedabad SQL Server Usergroup Meeting on August 30, 2008. I will be taking sess … more →

Tags: SQL, SQL Authority, SQL MVP, SQL Server, SQL Tips and Tricks, SQL User Group, SQLAuthority Visit, SQLAuthority News, T-SQL

SQLAuthority News - 4 Million Visits - over 675 SQL Server Articles

pinaldave wrote 1 month ago: Thank you to all of my readers for supporting this blog. It has been wonderful journey all the way. … more →

Tags: technology, SQL Server, SQL, dba, Database, SQL Tips and Tricks, SQL Authority, SQLAuthority News, Author Pinal

SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database — 18 comments

pinaldave wrote 1 month ago: Today in this article I would discuss about the Database Mail which is used to send the Email using … more →

Tags: technology, SQL Server, SQL, SQL Tips and Tricks, SQL Authority, Author Pinal, T-SQL, SQL Scripts, sqlcmd

SQL SERVER - UDF - Function to Convert Text String to Title Case - Proper Case - Part 2 — 1 comment

pinaldave wrote 1 month ago: I had previously written SQL SERVER - UDF - Function to Convert Text String to Title Case - Proper C … more →

Tags: Author Pinal, SQL, SQL Authority, SQL Function, SQL Scripts, SQL Server, SQL Tips and Tricks, T-SQL, technology


Have your say. Start a blog.

See our free features →

Find other items tagged with “sql-query”:
Technorati Del.icio.us IceRocket