Topics
Started by
Posts
Last post
Hi all i have a stored procedure that looks like this create procedure update_user @id int,…
6 replies
By: zsysop
I've noticed that the MERGE function in SQL Server 2008 does not appear to handle NULLs when compar…
2 replies
Hi All, I have a table with an index made of two fields ( A, B) I need to select all records with u…
9 replies
hi there, I have the following script that creates two table that I am trying to join together on v…
3 replies
HI, I WANT A LOGIC FOR ORDER MATCHING SYSTEM. SRNOCLTCDBUYSELLQTYMATCHMATCHSRNO 1A001SELL…
2 replies
Hi All, I would like to know how to select only one record per id. the records are not duplicate. I…
3 replies
Hi I was working on some SQL when I came across this unexpected result - unexpected to me that is. …
1 replies
hi people, i'm studied sql server 2008, and i've code: CREATE PROC dbo.usp_AddEmp @empid AS INT…
8 replies
How to know is the backup file is compressed while taking backup from database. Ex: I have a sql se…
3 replies
I have the following query: SELECT LEFT(GL_ACCT_ID,2) as FundCode ,RIGHT(GL_ACCT_ID,5) as Object…
2 replies
Evidently there's a lot for me to learn about sorting. I need to sort by Title(varchar), but the '…
5 replies
Hi, I did a backup of a table by doing a select * into #temp from table. If for whatever reason, …
7 replies
Hi guys CREATE TABLE [dbo].[b1]( [b1] [int] NOT NULL, [b12] [varchar](10) NOT NULL ) GO CREATE T…
2 replies
Hi All I would like to have regions in my code but it doesnt look like I can have these in 2008 In …
4 replies
I have SP with two conditions true and false. Its taking false condition if i run the procedure as …
1 replies
Viewing 15 topics - 10,591 through 10,605 (of 10,647 total)
You must be logged in to create new topics.