Topics
Started by
Posts
Last post
Create Procedure SPPS @Year1 int, @Year2 int ,@Year3 int ,@Year4 int ,@Subject1 int ,@Subject2 int,…
2 replies
hi! I need to know the default data file & log file path of database.Is there any stored p…
8 replies
Hello, I have a problem when trying to write a Dynamic SQL query. I Have a UserDefined funtion to …
6 replies
I am plowing through a data warehouse load script, and this statement is executed in a script on SQ…
3 replies
The address field in my User table has data like: 1905 1905 S OAK ST 314 ROSSELL AVE 252 252 HIGH M…
5 replies
while connecting to views in SQL Server 2000 I am getting the message "Server: Msg 4414, Level 16, …
4 replies
Hi all, How to get duplicate value from any column... suppose i hv a Table 'tblAuthorArticle' and t…
1 replies
How do I get a trigger to act upon just this record. I have read up a little on triggers but cant s…
6 replies
I'm trying to figure out a database that a customer provided. It's either a crap design, or more no…
7 replies
I have a text file and I want to use bulk insert, I have header records and detail records, how can…
4 replies
CREATE FUNCTION GetItemSoldCount ( @ItemID int ) RETURNS int AS BEGIN …
1 replies
I get this error when executing a query : 1203: Process ID 52 attempting to unlock unowned resource…
12 replies
I have 2 tables like table-1 and table-2. I want to represent data like table-3. Is there any…
2 replies
What is the best way to find out whether database is readonly state or read write state? My require…
1 replies
First off hi, secondly, I hope this is an appropriate thread for this query. Right, my problem...I'…
4 replies
Viewing 15 topics - 1,711 through 1,725 (of 7,464 total)
You must be logged in to create new topics.