Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
believe
Starting Member
3 Posts |
 Posted - 2011-11-16 : 03:56:33
|
| I`ve got error Server: Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword ORmy writing in query - alter table dbo.memb_info add purse nvarchar (50) not null default 1 OR PRINT "Van`t add Purse" column<BR> ; What i shold do? |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-11-16 : 04:38:35
|
| What do you want to do with default definition? You can't use OR option thereMadhivananFailing to plan is Planning to fail |
 |
|
|
believe
Starting Member
3 Posts |
Posted - 2011-11-16 : 04:44:58
|
quote:
Originally posted by madhivanan
What do you want to do with default definition? You can't use OR option thereMadhivananFailing to plan is Planning to fail
I needed to manualy set website skript in mssql query analayzer because the install won`t work propriet, so what i need to use ther? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-11-16 : 04:55:11
|
| Do you want to update the column with that specific value? Use UPDATE statementMadhivananFailing to plan is Planning to fail |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-16 : 05:02:50
|
| sorry your statement doesnt make sense. You want it to take value as 1 and print message also?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
believe
Starting Member
3 Posts |
Posted - 2011-11-16 : 05:12:44
|
quote:
Originally posted by visakh16
sorry your statement doesnt make sense. You want it to take value as 1 and print message also?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
I finished it, but the problem wherent in steatment i needed some extra tables where it go`s to. Thx you anyway.. |
|
|
|
|
|
|
Query