CREATE TABLE [dbo].[TMovie](

[Key] [uniqueidentifier] NOT NULL CONSTRAINT [DF_TMovie_Key] DEFAULT (newsequentialid()),

[Name] [varchar](100) NOT NULL,

[Source] [varchar](50) NOT NULL CONSTRAINT [DF_TMovie_Source] DEFAULT (app_name()),

CONSTRAINT [PK_TMovie] PRIMARY KEY CLUSTERED

(

[Key] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE =...

thanks a lot all

thanks

are you of this information? is there any reference for this information?

thanks

I've read that in this topic:

http://www.sql-server-performance.com/articles/per/derived_temp_tables_p1.aspx

thanks all

but temp tables have problems in performance since they make locking for the server when it's under construction . I used derived table to enhance performance . will the...

thanks

but I don't want to convert Varbinary To String ,I want to convert nVarchar to varbinary (the inverse conversion) 🙂

hi

I'll add extra script to get default value for each column first if the equivalent passed parameter is null ,something like that:

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

create table #temp

(

column_name sysname,

column_def nvarchar(4000)

)

insert into #temp SELECT...

thanks alot

I shall study that and test it,any way my current code is

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

CREATE PROCEDURE [dbo].[sp_Table_1_Insert_WithDefaultValues]

@c_varBin varbinary (50) = null ,

@c_varBin_max image = null ,

@c_smallInt smallint = null ,...