this my table with test data

CREATE TABLE [dbo].[Karmand](

[KarmandID] [smallint] IDENTITY(100,1) NOT NULL,

[SematID] [tinyint] NULL,

[FName] [nvarchar](50) NOT NULL,

[LName] [nvarchar](50) NOT NULL,

[Sh_Sh] [decimal](11, 0) NULL,

[FatherName] [nvarchar](50) NULL,

[Birthday] [varchar](10) NULL,

[Tel] [varchar](11) NULL,

[Mobile] [varchar](50)...

ok i got it thanks alot

1-for example in insert , delete , update i must use function or store procedure? could u give me example for store procedure and function

2- if our select has parameter...

Jason-299789 that work but i dont know how to mark it as answer

I edit My question with creation table and insert test data query and say all the detail

Gazareth (10/9/2012)

---

vahid.arr (10/9/2012)

---

Performance is not important Because I want To Do it One Time.I want All Removed Data from My Main Database Come to Another Database So I remove...

Gazareth (10/9/2012)

---

Lokesh Vij (10/9/2012)

---

Gazareth (10/9/2012)

---

Only one table at the time can have...

Lokesh Vij (10/9/2012)

---

It will certainly work. Execute the query - this will...

SELECT DISTINCT 'SET IDENTITY_INSERT '

...

NO friend

I want To Set Identity Off for All Tables not drop table.

yes the database is central and is in the server but i cant Find Sql Account on security tab.where exactly is that?

i want alo info of last date of AraziEghdamat and when I want To select them it give this error:

Msg 8120, Level 16, State 1, Line 1

Column 'AraziEghdamat.Eghdamat' is invalid...

tnx Dave Ballantyne

I solve All Of them Except This one :

I have Table with 40 column that 10 column of that table is Image Type(varbinary(max)) and my question is that:

is it not...

What is the question here. Seems a bit overkill to have 40 varbinary(max) columns in the same table. I suspect normalization would help here but with no more details it...