how to use newid() in sql insert query with asp

Question

0.00/5 (No votes)

See more:

in inline insert query I can write
"insert into table id=newid()..."

In parameterized query in c#

"Insert into table (name,id) values (@name,@id)..."
sqlcommand.parameter.addwithvalue("@name","souvik");
sqlcommand.parameter.addwithvalue("@id",?);

how to use newid()?

Posted 8-Jan-15 23:45pm

souvikcode

Add a Solution

Comments

Sanket Saxena 9-Jan-15 8:24am

Why you are inserting ID via parameter. Any specific format you want? If not then just manage it via SQL no need to pass anything from here SQL will take care of it.

3 solutions

Solution 1

NEWID is a function, you can't use it as a parameter (you should call it explicitely in the insert statement). Please see the documentation: "NEWID (Transact-SQL)"[^].

Posted 9-Jan-15 0:11am

CPallini

Comments

souvikcode 9-Jan-15 6:53am

Then how can I insert unique value in that id field?

souvikcode 9-Jan-15 7:05am

I've tried this and this works.

"Insert into table (name,id) values (@name,newid())..."
sqlcommand.parameter.addwithvalue("@name","souvik");

Solution 2

I would suggest to use this function in default constraint for ID Columns

for Eg:

create table abc
(

name varchar(20) not null,
ID varchar (16) default(newID())

)

now write your insert statement as below:

Insert into ABC(name) values ('person1')

Note that you can use various datatype instead of varchar(16) as per your requirement.

Posted 9-Jan-15 1:15am

deepakdynamite

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

souvikcode · Accepted Answer · 2015-01-10T04:49:00

Solution 3

insert into table (name,id) values (@name,newid())..."
sqlcommand.parameter.addwithvalue("@name","souvik");

Posted 10-Jan-15 4:49am

souvikcode