Topics
Started by
Posts
Last post
We have a third party SQL 2000 Database which is suddenly giving strange results in that a simple e…
8 replies
How do I do this? I have a XML data type with XML text in it. How do I view the XML as a table? I…
13 replies
Table Data --------------------------- ID Dept-ID Version 10 30 0 20 30 0 20 30 …
4 replies
I have the following SP that runs daily. ALTER PROCEDURE [dbo].[usp_token_disable] AS BEGIN set noc…
2 replies
Hi, I need to identify what logins exist and what access they have to each database on the server. …
4 replies
Hi folks, I need to add code to an existing dos batch file that will return one single row of data…
5 replies
An existing trigger prevents bulk data insert into a database. In a stored procedure that pushes da…
9 replies
This is my main (and simplified) table: if object_id('tempdb.dbo.#Scan') is not null drop table #sc…
7 replies
Hello, I have a problem designing a table from a matrix in excel. Is it even possible in SQL Server…
5 replies
I have a column value like this 'Merged Facility Id:0286- Patient Id:999000 PHPatId:28488 with Faci…
6 replies
I have written a stored procedure where I am using a TRY .. CATCH block, but that CATCH wasn't bein…
8 replies
Hi All, I have a table with below data create table t1 ( name varchar(50) ) insert into t1 select '…
10 replies
I'm trying to insert records to a table with identity column. I first set it to on and try to inser…
7 replies
Given a table like this declare @Tab1 table ( id int identity(1,1), v1 int, v2 int, v3 int, v4 int,…
25 replies
Hi all, I used sqlcmd -U dbName -P password -S hostName -y 0 -u -d dbSchema -i C:\MyLargeScriptFile…
2 replies
Viewing 15 topics - 1,606 through 1,620 (of 12,234 total)
You must be logged in to create new topics.
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy