Topics
Started by
Posts
Last post
DECLARE @MyRelations TABLE ( SubjectID VARCHAR(8), RelatedID VARCHAR(8) ) INSE…
5 replies
hi , i need to have the current 'thisyearmonth' expressed as 201008 means august 2010 has to be exp…
4 replies
hi, I have this table Structure for international dialing Codes and Tariffs: CREATE TABLE [dbo].[T…
8 replies
Hello, I am trying to import an excel file in SQL Server 2005 through "OPENROWSET" command.…
3 replies
I have two tables A(BookNo) B(BookNoFrom,BookNoTo,ChangeBookNo) Create table A(BookNo char(4)) Crea…
3 replies
Hi Anyone can help me below I want to create index for below scripts in sql 2005. the correct index…
2 replies
Hi, I have to create a report for billing to clients: Here are some details: -- create sample tabl…
7 replies
Hi All, i had a xyz sp in abc database.. when i ran the select * from sysobjects where name like…
2 replies
Hi, I have a database with several tables, containing clinical info. One of the tables (let's name …
5 replies
HI I HAVE A TABLE CREATE TABLE [dbo].[Url]( [UrlID] [int] NOT NULL primary key, [UrlName] [varc…
1 replies
Hi, Been a while since I have visited here. I have got a query which gives me a result set shown be…
13 replies
Hi, Been a while since I have visited here. I have got a query which gives me a result set shown be…
2 replies
We have a table containing a single row, single column (bigint) “counter” value (1,2,3,4…). We cre…
24 replies
The deadlock revolves around 3 tables (A, B, and C), shown simplified below. ----------------------…
3 replies
Is it possible to apply the replace function to all columns in a table? I have over 350 in a table …
3 replies
Viewing 15 topics - 9,391 through 9,405 (of 10,635 total)
You must be logged in to create new topics.