As of now there is no direct command is available for this, Its In the wish list for future releases

You can easily do...

Try this

Select

COALESCE(CASE RTRIM(Mobile) WHEN ''...

Change Null to ad_num in Case statement like this

update @table

  set ad_num =

  case

  WHEN (CHARINDEX(' ', ad_str1) < 10) AND (CHARINDEX(' ', ad_str1) <> 0)

    --creates...

You can try this

select

name, fn, val,cast (val/0.65...

When you create a PRIMARY KEY constraint, a unique index on the column, or columns, is automatically created. By default, this index is clustered; however, you can specify a nonclustered...

You can get this information from Information_schema views like this

select

* from information_schema.columns where column_name

try this also

Select max(startdate) as startdate, max(starttime) as starttime, max(page) as page, p.pageid FROM Page_History P

Inner Join

(select pageid,max(startdate) as maxdate from Page_History Group by pageid) B

on p.startdate=b.maxdate and p.pageid=b.pageid

Group by...

use dynamic sql

declare @param sysname, @sql nvarchar(4000)

set @param ='tablename'

set @sql='Create table '+ @param+'(sno int)'

exec sp_executesql @sql

try this for your problem

CREATE

Function dbo.fnAFCompExitCTMgrAI(@YYear int , @MonthNum