Topics
Started by
Posts
Last post
I had found some elegant code posted here to calculate the number of days minus weekends between tw…
1 replies
I am inserting unicode data in SQL server using insert statement as follows, INSERT INTO tablename…
3 replies
I'd like to search for a string within a text (binary) column. Some searches seem to fail, and I ca…
1 replies
I am using a system to determine a country name from a telephone prefix. Right now I cursor throug…
16 replies
Hi, I would like to create and fill in a table with the resultset of a subquery. Something like : "…
5 replies
Hi all, We have a linked server which we need to query. This works fine as a linked server (SQL200…
1 replies
I have created a trigger on one of my data tables to execute a DTS job eg: EXECUTE msdb.dbo.sp_star…
10 replies
Hai All, I taking the details of employees through VB6 SQL Server2000 application using ADO 2.6, I …
3 replies
In oracle, we would create a trigger based on the change on a column. Could SQL Server do it? If ye…
2 replies
Hi! Lets say it I have 2 tables. First one has Name and eMail and second one has ID (Identity), Nam…
1 replies
I created insert/update and delete triggers that run a procedure with 3 parameeters for each insert…
4 replies
I have just inherited a database with a log file size of 3.5GB, but the actual data used in the log…
2 replies
hello i need to know how i can calculated number of days elapsed between two dates on a TSQL statem…
2 replies
On a SQL 7 database the following stored procedure was defined. CREATE PROCEDURE LoadPOs @ParentTab…
7 replies
hi! im having a rather complicated query to be written There are 2 tables members and franchisee in…
4 replies
Viewing 15 topics - 16,876 through 16,890 (of 17,082 total)
You must be logged in to create new topics.