Programming SQL

Re-seeding an IDENTITY column
Is there any way to re-seed an IDENTITY(1,1) column back to recommence at 1 without DROPPING the table but after a DELETE FROM table? SQL Server 2005. Thanks. ... 10 Jul 2008 23:43

enum in sql
In C# [Flags] private enum Action { Ok = 1, Cancel = 2, Retry = 4, Help = 8, Action1 = Cancel | Help } How do I store and query something like this in sql with a single column? how can i query (Action1) without having to write all the combinations Thanks Tem ... 14 Jul 2008 11:38

Avoid Null columns in Table
Hi Guys How should avoid null columns in a table. Ex I have Table called Test Emp_code Name DOB place dest add1 add2 DOJ 111 yesvanth 18-may-1984 null null null null 26- nov-2008 ... 10 Jul 2008 16:32

Create a different connection from TSQL
I am attempting to write "unit" tests for my procs. one of those procs uses @@spid as a value in the table. I need to write a test that will check a different value of @@spid. I was hoping for something like this (but i can't find the TSQL for it) (do the stuff before) CONNECT server, db, userid ... Test wi... 11 Jul 2008 15:06

Retriveing the status of SQL Server Job before running sp_stop_job
I want to run sp_stop_job to stop a SQL Server job but I get an error message that its not running. How can i check the status of the job before applying/not applying sp_stop_job to stop it? Many thanks Chris ... 10 Jul 2008 14:28

basic SQL insert questions
I'm getting a syntax error, it says near ',' - not very helpful. How do I specify the data for (a) a bit column (b) a datetime column Here is my insert (as mangled by query builder): INSERT INTO dbo.Parent (FirstName, MiddleInitial, LastName, GroupId, SSN, Phone1, Phone2, Address1, Address2, City, State, Zip, E... 10 Jul 2008 13:25

Code folding in Management Studio 2005?
Hi all, I'm working with SQL Server 2005 Management Studio. Is it capable of doing code folding? Is it any tag I can use for hiding lines of code at will? Thanks in advance Sammy ... 11 Jul 2008 09:56

Vista SP1 and local sql2k5
I develop on my laptop with a local copy of sql2k5. After installing sp1 for vista biz, I am no longer able to connect my apps to the local sql server. The apps do work just fine with the production server. Where to begin troubleshooting? Jeremy ... 10 Jul 2008 21:40

No default instance?? Adding an instance to same server?
Doh.. SQL 2005. what if the only instance on the DB server was MyServer/BadName .. and attempting to connect to MyServer (default) was of course not possible. How could this have happened? Any way to create the default instance? Best way to add a new instance? and is instance even the correct term? than... 10 Jul 2008 13:25

Query performance help
I am trying to do some radius search within a zip code and just to get the counts it's taking about a minute. Is there any way I can improve the performance on below query. I already have an index on zipcode field and also on the field that is used for joins which create the view. I am pulling the data from an ... 10 Jul 2008 12:23