Topics
Started by
Posts
Last post
I would like to create a list in SQL from a Declare statement. I have the following script: Select…
5 replies
HI, I'm trying to execute bcp from a sotred proc. calling xp_cmdshell and only get this error.…
4 replies
DECLARE @t_date varchar(10) select @t_date=convert(datetime, dob) From dbo.Customers_Log PRINT(@t_d…
9 replies
When I run an SQL statement to retrieve the extended properties of a column it always returns <B…
2 replies
On the following excerpt from a SP, I am trying to figure out why I can't get a value returned for …
2 replies
Hi there everyone? i have setup a trace for my datadase to audit all transactions and login informa…
2 replies
Hello, I have an SP with 10 different SELECT statements in it so returning 10 different resultsets.…
4 replies
OK just had a really weird thing happen at a client's -- a sproc with a read only, forward only cur…
23 replies
Hi guys, In SQL Server, assignment operator operation cannot take a text data type as an argument. …
8 replies
Hi all, How can I simulate a block on the server for testing purposes? I don't want to inser…
3 replies
Hello all, Does anyone have an idea of how to trigger calling an asp or aspx page from within a sto…
5 replies
Hi, I have a stored procedure where I am carrying out two updates. To ensure data integrity the fi…
1 replies
I have applicants on my database who have a list of temporary jobs they have been assigned to. Usin…
8 replies
Hello i have this query can someone help me to transform this query in dynamic sql ? as the clause…
3 replies
hi, can anyone help me how to transverse rows into columns in SQL. for ex, I have a table with dat…
3 replies
Viewing 15 topics - 10,816 through 10,830 (of 17,082 total)
You must be logged in to create new topics.