We just want to know the how many column and table used in sql select stament

You have create two function One for

Encrypt(F_EncryptString) the String and another decrypt (F_decryptString) the string.In both function you have to use same passphrase string.

In sql Sever 2005 onword U can use passpharse method to encrypt/decrypt the string if you do'nt want to maintian the master key

DECLARE @passPhrase NVARCHAR(50),

...

Below query will work for yur case ,

SELECT * ,dense_rank() over ( order by letterId desc ) FROM #History

order by HistoryID

Try This Sql Statment,

DECLARE @String VARCHAR(1000)

SET @String='4690573010230001982347982354378346';

WITH cte

AS (SELECT Cast(Stuff(@String, 4, 0, '.')AS VARCHAR(1000)) AS nbr,

...

Check Below SQL and let me know if it's work for you

use tempdb;

go

create table stu( id int , name varchar(10))

insert into stu(id,name)

select 1 id, 'x' name union all

select 2,...

Check Below SQL and let me know if it's work for you

use tempdb;

go

create table stu( id int , name varchar(10))

insert into stu(id,name)

select 1 id, 'x' name union all

select 2,...

Call store procedure and in store procedure define parameter as OUTPUT.

U can check the url

http://msdn.microsoft.com/en-us/library/ms187745.aspx

Use Case statment to update the wrong Entered data

If you don't know how many subject u have then use dynamic SQL and get the result.

I Thing you are looking for

SELECT CASE

WHEN CASE

...

Good question,

Thanks

Use just simple transaction

begin try

begin tran

SELECT * into table1 (col, col2...)

FROM table2

DELETE FROM table2 --Need to rollback table2 data if script gets failed...

Try This and let me know if any issue

SELECT MONTH

FROM (SELECT DISTINCT( Convert(VARCHAR(6), DATE, 112) ) AS MONTH,

...