Search results for query: *

Hello. In the same database, I want to create two new stored procedures each with different QUOTED_IDENTIFIER settings. That is: --- Script 1 creates PROC 1 first SET QUOTED_IDENTIFIER = OFF GO CREATE ProcA ...... --- Script 2 creates PROC 2 second SET...

Hi. I have a table Employee with ID, Name and Country column 1 John Doe USA 1 John Doe CAN 1 John Doe GBR 2 Sally Jo CAN 2 Sally Jo MEX I want to produce this result set: 1 John Doe USA, CAN, GBR 2 Sally Jo CAN, MEX Is there an efficient way to do this...

Greetings! Is it possible to grant limited access to view and modify jobs? I have some sql jobs set up.. the jobs run queries against a database called "Export". I want to grant a new user full access to the export database and also allow him to make changes to these jobs. At the same time...

Hi guys, I 'll try to be articulate on this one! On Table A, I have an insert trigger that calls a stored procedure. The stored procedure contains local temp tables (#tempTable). Considering that many records can be inserted into Table A at any time, at close intervals and by the same person...

Hi everyone, I have two tables (with the same structure) that i want to compare for equality. Is there an easier way to do it than 2 left joins? If possible, I would like just one statement to return a single result (same or different). Unfortunately, there are 5 fields that i am comparing :(...

Hi Everyone! Does anybody know how to assign a variable to a dynamic sql statement result? The code below works until I reach the last line where I try to assign my variable... I am very unsuccessful! ---START DECLARE @Table nvarchar(100) SET @Table = 'TestTable' DECLARE @SQL nvarchar(1000)...

Greetings all! Does anybody know how to easily scan a field for a list of specific characters and then return them? I have one simple table with one field: "StringList". My table looks like this: "StringList" ----------- John Doe XYZ aeixyz try try I want to scan the...

Hi. I inherited a website and am having problems! I receive the following error: ---------------- Microsoft VBScript runtime error '800a01ad' ActiveX component can't create object: 'CryptCOM.Crypto' /statements.asp, line 124 ---------------- The error occurs on line124, which is set...

Does anyone know if it's possible to export data into a tab delimited file from a PASS-THROUGH query? I am able to use the following, but not with the results i want: 1) DoCmd.TransferText - I can only use with a table or regular select query. If I try my PASS-THROUGH query, it fails. 2)...

I was wondering if somebody can please help me understand codepages. Specifically, I am trying to understand the difference between a CodePage and a characterset. What is really confusing me is UTF-8 - is that a codepage? What brought me to this is Japanese Characters - are they in a UTF-8...

Hi Everyone - I have an Access database and I would like to prevent the users from viewing/accessing the database window. I have unchecked the start-up "Display Database Window" in the tools and that works. But if the user clicks on SHIFT while opening the database, they can get the...

Hi All! I bet I can stump ya! I have a trigger on a table and the trigger calls a stored procedure. I would like to capture errors in the stored procedure but for some reason, SQL Server will not continue commands after the error - it simply stops and hence, I cannot capture/raiserror. What...

Hi! Is it possible to make some columns read-only and other columns updatable in the same table? I know you can make an entire database read-only, but am not sure about having part of a table read-only while other columns are updatable. Ideally, all but one of the columns would be static, the...