Search results for query: *

Or select * from table where (@vdate is null or mydate > @vdate) This might be slightly eachier if you have lots of arguments of this flavour.

Well, if the insert /update fails because of a constraint, you'll get notified at runtime - this notification will depend on the environment you are using, alternatively, if you want to see how many rows an update /insert /select affects, you could use the @@rowcount variable eg: select * from...

I have recently had a similar problem, I solved it by initially binding the Crystal report to an ADO active data datasource (pointing a some psudo-temporary table, with the same structure as the output from the stored procedure). Then at runtime, create a recordset from the results, passing in...

I agree, I think the only way to solve it would be to come up with an expression to relate col2 to col1, if you plot them against eachother it seems to be a relatively smooth curve, so this might be possible, then you could rely on a cartesian product ... select * from tblTest col1, tblTest...

You can maintain a seperate table to hold the last value of the key for all other tables: NextIdentifier: TableName varchar(255) NextIdentifier int Everytime you need to write row to a table you have to read this table, then . The big problems with this are: You always incur another read and...

Remember, you are probably using an Anonomous connection to IIS, otherwise external people will not be able to connect to you website. This means that the connection credentials used by IIS to connect to SQL server will be it's own, and not the user of the web page.

Consider detaching the database, copying the device files and reattatching them on the 2000 server. This is certainly the simplest method. ... sp_detach_db mydatabase (copy files to new server) Do this on both servers ... sp_attach_db mydatabase, 'datafilename', 'logfilename'

My recommendation is to format all dates as dd/mmm/yyyy before sending them to SQL server: e.g. 10/mar/2001 SQL will automatically cast these nomatter what date format is set

Try: select convert(varchar, getdate(), 103)

To be honest this is not easy, the main problem is that an SP cannot take an undetermined number of arguments, if you settle for passing to the SP a comma seperated list you could use the following stored procedure: Note, you'll have to modify the select statement, I've created it, to look at...

I'm not exactually sure what you mean, but you can join two tables in an update statement: update a set id = newid, customername = newcustomername, updateDate = newupdateDate from a, b where b.id = a.id

You can view the source of all the system stored procedures, they are just like any other procedure except they reside in the master database, so to look at sp_spaceused: master..sp_helptext sp_spaceused You'll probably be suprised by the complexity of these procedures, but I think you want to...