Hi Team,

Want to execute a single query to fetch the numberic and alphanumeric values with following two queries

select cast(data as integer) from record_tab where ISNUMERIC(data) =...

Perfect...

Thank You.

How to remove first and last char from below select query

SELECT LTRIM(RTRIM(REPLACE('Micro Soft','M','m')))

output should be : 'icro Sof

Hi Team,

Above T-SQL code is exactly resolved my requirement, but i've two database tables (@replacements, @theStrings), how to use the below code with actual tables.

WITH rep AS (

SELECT string_id, theString...

Is there any possibility to export from SSMS without addins.

Hi Team,

The solution provided by are working fine..

but there is a change in my result.

my request is

if a record_1 is in Table_A and Table_B, then

output : record_id_1 :...

Trying to access using below statement, but no results.

exec master.dbo.xp_dirtree "\\113.218.216.127\New folder\txt\", 1, 1

Please help to acccess the files names from different machine.

Hi Team,

How to get the details from another server which does not have sql server installed on that machine.

Thank you, Thank you.

Its working good.

Table 1:

id | codes

----------------

001 | a,b,c

002 | e,g,t

003 | r,t,y,e

eg:

Desc_id | Code | Desc

--------------------------

001 | a | artb

002| b | byt

003| c...

Hi Team,

If there any possiblity to replace below char's in code column with string in another table.

id | codes

------------

001 | a,b,c

002 | e,g,t

003 | r,t,y,e

without using split function.

using above function, but how to include in view..

create function splitstring

(

@input nvarchar(max),

@character char(1)

)

returns @output table (

...

What exactly is this trigger supposed to do? Insert exactly the same value into a table every time any row is updated or deleted?

Yes,

Insert exactly the same value...

Thank you for your info..

i want to trigger in two scenaios,

1) after update - insert statment

2) and before delete - insert statement.

please suggest in above scenaio