USE [NiloyHero1920] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- sp_FindStringInTable...
Fresh Topics for Beginner
SQL Server
Search string in whole table (all row/column) in SQL
How to quickly search for data all over SQL database
Many a time we come across a scenario where we want to fetch data from all over database tables...
Execute Store Procedure with String Query in MSSQL 2008
CREATE PROCEDURE [dbo].[SP_GetBillDetails] @WorkshopID NVARCHAR(50)=NULL, @Type NVARCHAR(50)=NULL...
Searching (_) underscore in a Column SQL Server
This is done by adding the ESCAPE clause to your LIKE expression. The character that is specified...
How to Reset IIS using Scheduled Tasks Step by Step
It has been seen that sometime IIS will stop to work on unexpected reason, in this situation we...
How To Optimize SQL Queries
Why optimize a query? Many of us are feel the query that we wrote is final and once it works and...
SQL: Get all table names and their row counts in a DB
If you are looking for row count of all tables in all databases (which was what I was looking for)...
SQL: Find all database physical location and size
I encountered the situation recently where I needed to find the size of the log file, file location...
What is difference between primary key and unique key
Primary key and Unique key are two important concept in relational database, and used to uniquely...
Concatenate many rows into a single text string
Many a time, SQL programmers are faced with a requirement to generate report-like resultsets...
Interview QA
What is difference between TRUNCATE and DELETE in SQL?
Purging Tables in SQL Using TRUNCATE and DELETE command.
Android Tutorials
Variables and Data Types in Java
In short, Variable is name of reserved area allocated in memory. In other words, it is a name of...
