Topics
Started by
Posts
Last post
/* I'm writing a query for a report and I need to combine multiple values into a a single field for…
11 replies
The store procedure write about 6 million records in a table and is taking alomst 36 min to process…
6 replies
Hi, I would like to know how can I make an INSERT in a Stored procedure that receives the values t…
4 replies
alter procedure sp_checkdbaccess AS /*Copy the output of this sp and run it on query analyser*//*T…
1 replies
Hi, I have three columns and want to update the third column based on the comparison of first two c…
1 replies
Hi all, I have a text which will be passed to a procedure / function and the procedure / function h…
3 replies
Hello, please bare with me as I am new to this. We have two SQL 2005 Database Systems. After an upd…
1 replies
OK so I've built myself a nice ASCII table in SQL with the ASCII Code, the character it represents …
3 replies
Hi , I want to define default constraint for a column to force it to UPPER. USE [GLP] GO ALTER TAB…
2 replies
Hello, I'm fairly new to T-SQL and SQL in general. Can someone point me to a good source for learni…
2 replies
Hi there, I have a datetime field that gets recorded in my db everytime an item is added to the tab…
1 replies
I have start date and end date fields in database where I want to scramble the dates. How to create…
31 replies
hi guys, I am creating a transaction in which it first does a select and then it does an update, my…
14 replies
I am using following query to build a table. right now this query takes about 3 hours. which is way…
5 replies
TableA ( empid , empname ) TableB ( empid, Emprole,EmpSal) I wan to look up TableA with TAble B, i…
1 replies
Viewing 15 topics - 9,961 through 9,975 (of 12,230 total)
You must be logged in to create new topics.