Topics
Started by
Posts
Last post
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
Hello, I have an ActiveX-EXE written in VB6. This Exe is compiled and is running on the server. I'm…
2 replies
Hi, Looking for help with function. InputString= John[Sam]Will[Joseph]Smith[Joe] Output table value…
2 replies
I have the following procedure that's suppose to drop a constraint. How do I add the If exist clau…
1 replies
Can you provide websites/books/info to fully learn and master T-SQL. I sometimes struggle and waste…
3 replies
Hi Everyone I have a table of schedules that shouldn’t overlap (date- and time-wise), and I’ve been…
3 replies
Hi, I have a column which has numbers 1, 2, 3. I want to replace the value in this column. Say if i…
2 replies
I have a production database with a significant number of columns, and I am curious if there is a w…
5 replies
Viewing 15 topics - 10,591 through 10,605 (of 10,640 total)
You must be logged in to create new topics.