Topics
Started by
Posts
Last post
I am supposed to create a join condition between two tables. 1) This one with nvarchar data type a…
3 replies
By: lucky.su
Dear All, When we shrinking the database , that will reduce the database Size But I need to know, …
1 replies
By: ps.
Dear All, When we shrinking the database , that will reduce the database Size But I need to know, …
1 replies
By: ps.
Dear All, When we shrinking the database , that will reduce the database Size But I need to know, …
1 replies
By: ps.
I have a stored proc on a DB that runs once an hour that analyses recent web traffic. At the beginn…
1 replies
Hi there, I have a table that has an identiy column as the primary key. My question is how do I ge…
4 replies
I've had a fairly good look (google) through various scripts about age, as it is somewhat problemat…
1 replies
I have a simple table that is just an inventory of my sql servers. The table is structured like th…
8 replies
If I have two tables as follows: A (ID, x, y) and B (ID, x, y) where ID is a one-to-one PK relation…
5 replies
By: SwePeso
Hi All, I need your help to solve one query. I have one table like below format. create table temp…
28 replies
By: WayneS
I have a client who has database tables with columns in lower case. I need them in upper case, and…
3 replies
I have several tables broken out by years that contain a license number for each person. The perso…
10 replies
DECLARE @UserID INT DECLARE @PassWord VARCHAR(50) DECLARE @Ok INT SET @UserID = 101 SET @PassWord …
8 replies
By: Digs
Hi All, I have a xml file to import into SQL server 2005. Now the xml file has a description sectio…
4 replies
I am new to sql server so I was hoping I could get some help? I have a table structured and populat…
3 replies
Viewing 15 topics - 6,046 through 6,060 (of 12,230 total)
You must be logged in to create new topics.