Dropping Constraints 3

Dropping Columns 2

Dropping Columns 1

Drop Column

Drop Column after checking regular constraints and dropping these constraints

RE: Error 21776: [SQL-DMO] Error

You can check sp_helpdb to see if it is there. If it shows up there you might want to refresh your database list in Ent. Manager. Or even disconnect to the Server and reconnect. Good LuckChuck

RE: getting year from string

try this:SELECT substring(field,CHARINDEX('/', field)+1,4) from table

table name from variable

Hi all, I have this problem: I should make a script that open a table whose name is given dinamycally; so I tryed using a simple variable, but if i write a query like this:declare @tab varchar(20) set @tab = 'TABLE' select * from  @tabI get this error: Server: Msg 137, Level 15, State 2, […]

RE: What makes a good developer?

What would be nice is you could alias common phrases. eg: Declare FU*K_OFF = GOTO Err_Handler If your code you could then have: ON ERROR FU*K_OFF Cheers, Crispin