I think you need to find a diffferant way to acheive this. Inserted virtual table has the same definition as of the real table so the studentname column will capture...

You are using dynamic string so the type of the variable does not matter.

Moreover you are getting this error when trying to concatenate the integer variable with varchar string 'Select...

Try

set @table_query='SELECT [ID], [Question_ID] FROM ['+@table+'] WHERE [Section_ID]='+convert(@sec_id as varchar(50))

Hi, you can acheive this through dynamic scripts. First you should find out the list of indexes in the particular filegroup. You can use sys.partitions to get this data.

select Object_ID,Index_id...

Filestream is the most efficient way to store unstructured data, and is available since 2008

You need to enable filestream for the database and add a filestream filegroup.

Alter the table...

Alan,

What you need to do is right click the Both tables in SSMS, select Script table as Create , paste the code in the forum. Otherwise whatever suggestions we...

You should look at the queries found in the deadlock trace and the resources that are being locked. You can try tuning these queries. But sometimes you may need to...

You are probably looking for constraint expression.

Check here

http://blogs.msdn.com/b/mattm/archive/2006/10/30/using-expression-based-constraints.aspx

Not really. The I dea is to think of all...

No, no . It will...

Backup contains only used pages (If it is full backup). No use of shrinking the database.

If it is a differential backup, it contains all pages changed since last Full backup.

So...

I am still not clear why your update is not working. One thing, your case statement should be changed

update dbo.BigTable set BigTable.Software_Version_Raw =

case

when CHARINDEX('.',Software_Version_Raw,0) >0 then

substring(Software_Version_Raw,0, CHARINDEX('.',Software_Version_Raw,0)...

We both wrote the examples with assumptions that you have only two patterns, if not you can go with the case stament itself

create table #SoftwareTest

(

SoftVersion varchar(500),

SoftVersionUpdated varchar(500)

)

insert into #SoftwareTest...

Jeff Moden (3/3/2013)

---

Heh... dang it. Roshan Joe beat me to it. You can, however, make it one notch simpler. Not sure which will be faster, though.

UPDATE...

alan

Try something like this

create table #SoftwareTest

(

SoftVersion varchar(500),

SoftVersionUpdated varchar(500)

)

insert into #SoftwareTest (SoftVersion)

Select '10.78.5'

union

Select '1.78'

union

Select '2'

union

Select '4.5'

union

Select '20.5'

union

Select '4'

union

Select '8.63.0'

union

Select '10'

union

Select '4.56.89'

update #SoftwareTest set SoftVersionUpdated=

case when CHARINDEX('.',SoftVersion,0)...