Check If Column Exists In Table Of SQL Server
Tips and tricks to check if column exists in a SQL Server database table. Also find the list of all tables and stored procedures having the column name.
SQL Server 2012
Encrypting Stored Procedure, View & Function in SQL Server
Encrypting stored procedure in SQL Server for hiding the source code of the stored procedure, view and function. Using WITH ENCRYPTION to hide source code.
Update From Select Statement in SQL Server
Update from select statement in SQL Server. Updating a table using select statement form the same table or different tables using join.
Joining Tables from Databases on Different SQL Servers
How to write a SQL select query joining multiple tables from databases located on different SQL Server Instances? Accessing table from remote SQL Server.
SQL Server: Search And Find Stored Procedure
How to search and find stored procedure by its name, part of the name, containing text and containing table name? Methods to search for stored procedures.
SQL Server: Search and Find Table by Name
How to search and find the tables by their name in SQL Server? Methods to search and find table in sql server using table name or column name or a phrase.
SQL Server: Find Table Creation Date
How to get the table created date time and modified date time in SQL server? There is an easy query to find the table creation date time in MS SQL Server.
SQL Server: Joining Tables from Different Databases on the Same Server
SQL query for joining tables from multiple databases on the same server. Joining tables from different databases in a single select query.
SQL Server 2012 Configuration Manager in Windows 8
Launching the Configuration Manager of SQL Server 2012 or 2008 on Windows 8. Locating the sql server 2012 configuration manager.
SQL Server: Does WITH (NOLOCK) increase performance?
Does with (nolock) increase performance in T-SQL Queries? Can you increase the performance of SQL queries by adding WITH NOLOCK? Lets find out.
Case Sensitive String Comparison on SQL Server
How to do a case sensitive string comparison on SQL Server using COLLATE. Case sensitive comparison in SQL Server 2008, SQL Server 2012, SQL Server 2014.
SQL Server Case Sensitive Search: Fetching lowercase or uppercase string
How to fetch lowercase or uppercase or mixed case, case sensitive string in SQL Server. Case sensitive search using select query. There are two simple ways .
count(*) or count (1) or count(”) Which is better in SQL server?
SQL Server: count(*) or count (1) or count(”) Which is better? Let’s do an experiment to find the better option among the count.
What is SQL Server? How to get SQL Server?
Do you want to know about SQL Server and how to get it. Here is a brief article about SQL server. This article will provide you a basic understanding about SQL Server.