Topics
Started by
Posts
Last post
I need to get only the time from the database col.So I used select CONVERT(CHAR(8),getdate(),8) jus…
7 replies
Hi, I want to append two TEXT data types. example : This is a query in one of my procedure. DECLARE…
4 replies
what is the max. number of tables we can store in a dataset what is the max. number of rows we can …
2 replies
Hi all, I've a table which look like this: id name team A B C D E F G H I J K L …
5 replies
Hi Guys I have a code just as below declare @a xml declare @b-2 xml declare @c xml set @a = (se…
1 replies
By: ItzMe
hi, I have a code like this declare @server decare @counterid set @server =... select Max(mem) …
4 replies
Here is what I am trying to do: update MyTable set [value] = (select BulkColumn FROM OPENROWSET(Bul…
1 replies
Hi, Please help me in understanding this deadlock graph Please check the attachement for the graph
5 replies
Hi, I have an update statement which will update 46 columns of a table based on one primary key. Th…
6 replies
Hi, table A which has 4 records union all Table B -has 4 records --getting result s…
3 replies
By: Sarwan
One of our developers came to me with a question and I don't know the answer. Although I'm doing s…
6 replies
SQL Gurus: I need to provide data from a SQL 2005 database up to four users at my work. I'm not sur…
8 replies
Can someone please tell me what book or training is best for writing stored procedures and developi…
1 replies
I am a newbie at this so I would appreciate any insight you may share. I am using Visual Basic and …
1 replies
When Creating a View................i am facing the error as.............. " Msg 8152, Level 16, St…
2 replies
Viewing 15 topics - 2,461 through 2,475 (of 4,155 total)
You must be logged in to create new topics.