Hi sharma,

Moreover there is no relationship between Employee table

with Address/Qualification table.

Tell me in which scenario you want the result set?

---

Hi niranjankumar,

All system Procedure's should start with sys.sp_.

And all the user defined procedure you want to find out by using the following stmts.

SELECT * FROM sys.sysobjects

WHERE [name] LIKE '%SP%'

AND xtype...

Hi Rob,

try this one.

IF EXISTS (SELECT * FROM tempdb.dbo.sysobjects o WHERE o.xtype in ('U') and o.id = object_id(N'tempdb..#md'))

DROP TABLE #md;

IF EXISTS (SELECT * FROM tempdb.dbo.sysobjects o WHERE...

hI PsycloneDBA,

try this one. this method will solve your problem.

SELECT 'Shower' AS [10001],'38' AS [10002],'Y' AS [10003],'Y' AS [10004],'1' AS [10005],4.1 AS...

Hi Paul,

whenever you want to use datatype length make sure you have entered

2ⁿ.

this one also be one of the advantages of performance.

ex:

---

...

Hi Stobbs,

Try this one.

DECLARE @refnum VARCHAR(128)

SET @refnum = '2143345345345345345345345342100712n3456789090987766544332211m'

SELECT SUBSTRING(@refnum,PATINDEX('%[a-z]%',@refnum),1)

---:)

Hi Ryan Randall,

WOW .... Great Man. Thank you very much ... 🙂

Hi Grant Fritchey,

I tried with cursor. Like this.

DECLARE...

Hi Grant Fritchey,

Thanks for quick reply.

We have to change...

Wow ... Thks Anirban Paul. i got it 😀

Moreover two more things are there as for as my concern.

1.Use brackets to enclose a range of characters, such as [a-f]

2.Use a reserved word as a field name. For instance,...

Hi massawa,

After creating the Script for the particular Database, you have to...

I tried through linkedserver. Plz check it out .... :w00t:

SELECT

*

FROM

sys.sysservers

ORDER BY srvid DESC

EXEC master.dbo.sp_addlinkedserver

@server = N'ExcelSte12'

,@srvproduct=N'Excel'

,@provider=N'Microsoft.Jet.OLEDB.4.0'

,@datasrc=N'C:\Book1.xls'

,@provstr=N'Excel 8.0'

SELECT

*

FROM

ExcelSte12...[Sheet1$]

In this "Sheet1$" is the...

try this one also ....

DECLARE @s1 varchar(16)

DECLARE @s2 varchar(16)

SET @s1 = '1232'

SET @s2 = 'tete,1232'

SELECT @s1,@s2

SELECT SUBSTRING(@s2,CHARINDEX(@s1,@s2,1),LEN(@s1))

---

Hi abhi,

try the below one. it may help you to sort out the problem. 😀

DROP TABLE #temp

CREATE TABLE #temp (ID int,AmountDue int)

INSERT INTO #temp (ID,AmountDue)

SELECT 1,5

UNION...