When calling this MS-SQL stored procedure: CREATE PROCEDURE [dbo].[AddUser] @networkID varchar(512), @id uniqueidentifier OUTPUT .... With this Groovy code: networkAliasID = 'aschoewe_test' sql.call("{call AddUser(?, ${Sql.VARCHAR}) }", [networkAliasID]) { s -> println "userID: ${s}" } I receive this error: java.sql.S...
In VBScript (ASP environment), is it possible to pass a parameter with a null value to a stored procedure? ...
I'm having a general discussion with one of my developers about philosophy of structuring TSQL stored procedures. Let's make a couple assumptions (to avoid responses along the line of "don't put business logic in SPs", etc): Business Logic can be in SPs There is no standard scripted layer of CRUD SPs Complex procedures are executed ...
What is the best column type for a URL field for SQL Server? Type: VARCHAR or NVARCHAR? Length? Similar question for MySQL. ...
I need to setup a JDBC connection string to SQL Server. This question is similar to the the C# ADO.Net connection question. This one is specific to JDBC connection strings. The usual format for the JDBC string is "jdbc:sqlserver://{host}:{port}". Now, for a SQL server cluster I have a cluster name vvv\iii ({virtual server}{instance nam...
I am checking whether a user has a permission to view the report through dataset stored procedure and if the user doesn't, raiserror is called. Is there a way to display a different message from SQL Server Reports 2005 when a stored procedure (that populates report dataset) raises error (through RAISERROR) instead of returning data? He...
I have a table with the following columns: SignatureID PatientID PatientVisitID TreatAuthDate HIPAADate DrugTestDate Now I have the following Select statement: SELECT * FROM tblSignature WHERE PatientID = 12345 This select statement returns 8 rows. What I need to accomplish is getting the MAX TreatAuthDate - and with that MAX Trea...
We are currently using SQL Server 2000 but will soon be moving to 2008. I am looking for a way to group related stored procedures into folders. SQL Server 2000 does not seem to have this ability and from my searches it looks like 2008 does not either. This seems like a basic feature that most users would want. Wouldn't it make sense to...
For SQL Server 2008 Developer Edition on Vista 64 bit: I tried copying a database using a Vista admin account using the attach/detach method and it failed due to a file permission error so I gave the user that sql services are running as write and modify to the directory. The copy didn't work. I then gave it full control. The copy wo...
I have a form that accepts text and is posted to the server. If a user were to input a French character such as 'à', it will be read as 'Ã' by Classic ASP code and be stored as 'Ã' in a SQL Server 2005 database. A similar affect happens to other accented characters. What's happening? ...
SQL 2000 The NED table has a foreign key to the SIGN table NED.RowID to SIGN.RowID The SIGN table has a foreing key to the NED table SIGN.SignID to NED.SignID The RowID and SignID are clustered primary keys that are guids (not my choice) The WHERE clause is: FROM [SIGN] A INNER JOIN NED N ON A.SIGNID = N.SIGNID INNER JOIN Wi...
I believe like many developers I have both Visual Studio and SQL Server installed on my PC. Since I use the PC for various tasks not just for development, SQL Server is by default stopped until I need it for another session of development. Currently I go directly to Administrative Tools->Services to start/stop SQL Server. Not that it bo...
Please provide guidelines on when to use DSV's as opposed to database views. Any performance issue using one vs. the other? Environment: SQL Server 2008 ...
I am for the first time trying to setup transactional replication. This is from an sql 2000 server sp3a to an sql 2005 server which I believe should work. I did a quick test on my local machine (sql 2005) using it as both the publisher and subscriber and had no trouble setting it up. I repeated a similar process for the real servers us...
Is there a way I can get a scripting of all tables, procs, and other objects from a database? I know there's an option to script the database but it only gave me some sort of top level script, certainly not a script to create all tables, procs, udfs, .etc. ...
I have the following scenario some real basic rest web service mainly, I'm just checking the existence of a single record, it's just a single validation, I'm not moving around hundreds of rows... that should be called from sql 2005, sql 2008... and yes sql 2000 and sql 6.5 (ouch!) I guess with sql 2005 and 2008 I could implement an as...
I copied over the mdf and ldf for a database (Sql 2005 Express) to my machine and in my Sql 2005 (Developer Edition) attached them. I had set the logging in the source machine to full since I need to research an issue. Now, in my SQL Server I have 2 database, DAProd that I just attached and DARestore that I just created. I want to resto...
hi guys, I have a registration table with primary key RegId. I have another table named Users, also contain RegId as Foreign key. When I delete one RegId from registration, I have to delete RegId from Users. Can anybody help? ...
Hi, I'm trying to write some generic code in VB.NET that determines whether or not a SQL server database table contains an identity column and, if so, to return the name of that column. I'm working in Visual Basic 2008 Express and have created a SQL database, "MyDatabase" with 1 table called "MyTable". Within that table, I've got 3 col...
i'm having a table called tblEmployeeNominees, this table consist the nominee member of the employee we can have more than one nominee for an employee, i want to display the serail numbers of the nominee members for the employee. if an employee has two nominee then it should have to show serial number for that employee as 1,2 if more tha...