i have a contact us table containing name emailid phoneno message repliedmessage as fields, by default the replied message field is null after replying to a particular message i am updating that field
Can I set NOCOUNT to be OFF by default for a particular database? I need it for NHibernate (if it\'s ON, I get exceptions when saving). I can see the setting to disable it for a开发者_运维问答n enti
I have one customer experiencing 5+ deadlocks per day.170+ other customers don\'t get any deadlocks at all开发者_Go百科.I\'ve implemented deadlock tracing and can see the select/update/insert deadlock
I\'m curently working on a project where I need to transfer data (with some minor transformations) from one database to another.Everything was going just fine when I hit my first Timestamp column...
I am working on SQL Server 2000. As you know, there is an application that\'s shows query results (Query Analyzer) The data is shown there, on a grid, and you can save that grid in a csv file. That\'s
I开发者_高级运维s there a way to find the unused tables which are nothing else but rubbish in database? The only way I can think of working out if a table is being used is to use sys.dm_db_index_usage
This is my logic. I have an articles table and a matching images tables. The images are stored in binary format. Each image table has 2 instances of each image, this is because I have 2 sizes. 300 x
I\'m sure this is discussed somewhere, but after searching for a while I can\'t find it. I\'m building a stored procedure for SQL 2000 and I need to build a lis开发者_运维百科t of numbers that I can
I am trying to populate a date table which contains every date for the next 35 years with information regarding each day.
I am using Linq-to-SQL (C# 3.5) to read two tables, house and county, from my database (SQL Server 2000). House has a CountyID column that matches an ID column in the county table. The County table ha
加载中,请稍侯......