How to Split a string by delimited char in SQL Server..............
However I posted this one in one of my post.
Querying Microsoft SQL Server : Functions in SQL Server: Functions in SQL...
2013-09-19
628,636 reads
Insert data from Excel to SQL Server
Here I am discussing about data insertion from MS Excel into SQL Server table. SSMS provides Export Import wizard by...
2013-09-16 (first published: 2013-09-11)
7,212 reads
Connection Pool limit exceeds Error
Sometimes below error occurs on our web applications hosted on IIS connected with SQL Server.
Timeout expired. The timeout period elapsed...
2013-09-13
32,208 reads
Sending Mail using SQL Server Express Edition
In SQL server standard and enterprise edition,A DataBase mail functionality in built to sent mail.But in SQL Server express edition,You...
2013-09-02
65,421 reads
How to find SQL Server Version,Edition,Server Name?
How to find sql server version,edition,Server Name?
SQL Server provides a System Defined function SERVERPROPERTY(propertyname) .
By using this function you can...
2013-08-31
26,254 reads
When and why you should use 1=1 in WHERE clause?
One Interviewer ask this question during interview of my friend.It is easy to answer but need some specific and to...
2013-08-24
1,259 reads
Remove duplicate records from a table in SQL server
Here I create a table and
inserted some duplicate records for testing purpose.
createtable temp(cust_id varchar(50))insertinto temp(cust_id)values('oms1'),('oms2'),('oms1'),('oms2'),('oms3')select*from temp
Method 1: (You can simply...
2013-03-19
3,834 reads
Querying Microsoft SQL Server : Basics of Indexes in SQL Server
Querying Microsoft SQL Server : Basics of Indexes in SQL Server: Indexes in SQL Server: If you see a book, in...
2013-03-13
923 reads
Querying Microsoft SQL Server : Basics of Triggers in SQL Server
Querying Microsoft SQL Server : Basics of Triggers in SQL Server: SQL Triggers: A trigger is a procedural code like stored...
2013-03-13
1,470 reads
Querying Microsoft SQL Server : Control Statements in T-SQL
Querying Microsoft SQL Server : Control Statements in T-SQL: Control statements are used to control execution flow within a T-SQL.Here I...
2013-03-13
752 reads
Blogs
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers