Programming SQL

How to narrow the selection
Dear all, When in SQL 2000. I can open the table and edit the cells with a sql query which narrow down the selection. Can I do that in SQL 2005. How to do that? ... 21 Dec 2009 09:06

Insert multiple rows with stored procedures
Hi Friend, You can use the follwowing format of SP to insert multiple rows of data in a single SP. You can pass values as comma seperated values. For the following SP Input can be: MemberId =10 MemberProductId =12,14,35,67,89 CREATE PROCEDURE dbo.insertMemberProductFavorite ( @MemberId int, ... 22 Dec 2009 12:37

loop between 2 datetime field values
led (l.r.m.d(a)sapo.pt) writes: i have availibility calendar that have rows with startdate and end date: select startdate,enddate where cod_casa="record from the first select" and livre=0 it is possible to loop between startdate to enddate? Well, you don't really loop in SQL. But say that you h... 24 Dec 2009 11:53

SQL 2008 passing Table-Value-parameters to stored proc via ODBC
Can we use row-wise binding instead of column binding with TVPs? Basically the C code I have generates a 25 column temp-array with 1-16 rows. The documentation for TVPs seems require 25 separate single column arrays. Help.......... Leon ... 22 Dec 2009 21:32

How do I creat a auto increment for my key field
Hi, How can I make a column auto increment ? -Ted ... 19 Dec 2009 21:28

Getting primary/foreign keys and referenced tables and columns
OK, I've been wrestling with this for a while; time to ask for help. I need a query (SQL 2005/2008) that, given a table name, will return the column information for that table as shown in SSMS (schema name, table name, column name, if it's a primary or foreign key; AND, additionally, if it is a foreign key - t... 18 Dec 2009 18:22

who to contact for content issues?
This newsgroup scraped a response I made on a non-microsoft SQL forum. On the original site I quickly deleted the post, but somehow it was picked up in this newsgroup. Who do I contact about having my real name removed from that post? It looks like it was scraped in automatically, so I have no way of deleti... 18 Dec 2009 23:51

SQL Server 2000 Virtual_Device question
Hi, My SQL Server 2000 log has recorded backup failed info: BACKUP failed to complete the command BACKUP DATABASE [GoodDb] TO VIRTUAL_DEVICE='{FB41ED2E-2437-4F6A-8FFC-AB42B43A5AA5}49' WITH SNAPSHOT,BUFFERCOUNT=1,BLOCKSIZE=1024 How do I find the VIRTUAL_DEVICE '{FB41ED2E-2437-4F6A-8FFC-AB42B43A5AA5}49' ? ... 17 Dec 2009 20:26

SQL Server 2000 Maintenance Plan and Win2003 Server Backup schedule
Hi, My SQL Server 2000 is on my Win2003 Server. The SQL Server 2000's Maintenance Plan has backup job, which is exactly the same time as the Win2003 Server file Backup schedule. Will that be a problem? Thanks for help. Jason ... 16 Dec 2009 12:23

Cascading deletion
I'm trying to find an example of cascading deletion via T-SQL code. Thanks in advance ... 15 Dec 2009 02:29