January 04, 2014
Get double byte / Single byte data from the table
In NVARchar DataType column we can store both Single byte and Double byte data. Many a times we want to know how many records have Single byte or Double...
Saturday, 4 January 2014
January 04, 2014
To Search a text from Stored procedure
alter proc usp_find_word
as
begin
select 'anuragggggggggggg'
declare @varrrrrrr varchar(50)
end
-------------------------
SELECT OBJECT_NAME(object_id),...
January 04, 2014
Joining Two Tables without any Common Column between them
create table #temp1
(
id int,
username varchar(50)
)
create table #temp2
(
age int,
sex varchar(1)
)
insert into #temp1
select...
January 04, 2014
How to find the text and get to know the stored procedure if you have lot of stored procedures
I have create a stored Procedure. As you know there are number of stored procedure and its tough to search a text if you want to find by text to know...
January 04, 2014
Error Line,Error Severity, Error State, Error Number,Throw , Raise Error in Sql server
ERROR_LINE
The Error_Line function returns the error Line number from code. This
function does not accept any parameters. The Error_Line() function...
Hello, my name is Jack Sparrow. I'm a 50 year old self-employed Pirate from the Caribbean.