Topics
Started by
Posts
Last post
check this out. if you are having adventure works data base it is there. u can check ALTER PROCEDU…
2 replies
hi, Just I am renaming the one txt file code :-- Declare @dt datetime ,@SQLstmt varchar(100) Se…
8 replies
Hello What is the tsql command to see the default filegroup on a database? Thanks
1 replies
I have a nightly job on my production database. This takes 30-40 minutes to execute. I looked into …
31 replies
I have been asked to rewrite the code, which uses xml to send multiple rows to the backend ,with ta…
10 replies
Hi, I have a SQL query, like so: SELECT DISTINCT ID, Name FROM Table This brings up all the distinc…
5 replies
In UNICA.SUBS table i have Account, TRANS_DATE, TRANS_TYPE, PROD_CODE and CODE columns. SELECT…
18 replies
Hi, I can't seem to wrap my head around adding an additional column to this query. DECLARE @strVal…
20 replies
Hi eneryone, Is there any way to run the query more than 8000 character via openquery? the query is…
15 replies
I need to import data into Sql Server Table from an excel File without using SSIS OR Import and exp…
5 replies
I have 4 SQL's that I process using SQLCMD. I have the output redirecting to log files. Most of the…
3 replies
Hi SQL guys, I still didnt got correct explanation for Clustered and Non Clustered. anyone? Thank y…
2 replies
Hello I just want to know how to query within a table by using its object_id for example Select * f…
14 replies
Hello, I have the following scenario: A multi threaded application which is writing into a table th…
2 replies
Greetings - I think I may need "Coalesce" here but can't get my head around it. I have a query tha…
2 replies
Viewing 15 topics - 8,266 through 8,280 (of 10,635 total)
You must be logged in to create new topics.