SQL - Windows Policy
How can I find out and set if an User is enabled or disabled using SQL commands? Same problem for windows policy enabled/disabled for an User. ...
sql
Sql Query for multiple tables
I Used SQL 2000 and database have following tables LandParcel (Table Name) BlockID ParcelNo NameofOnwe 11001 1056 Chandana 11001 1078 Sisil 11001 1158 Kumara 11078 105 SK 11078 245 Shantha Actions (Table) Blockid ParcelNo ActionTaken 11001 1056 Received 11001 1078 Received 11001 ...
SELECT IDENT_CURRENT(‘tablename’) in Oracle
Hello, I'm new with PL/SQL and I need last inserted id in data table after insert statement. Like on MS SQL SELECT IDENT_CURRENT(‘tablename’) Thanks in advance! Goran ...
Merge Data from Multiple Remote SQL Databases into One SQL Master DB
Hi, Well, I'm sure this question has been asked before but I'm yet to find a single solid answer to it. I'm in the process of creating a solution that involves remote offices uploading data to one master db via web service. Basically, each office will have a windows service that runs every 1hr or so, picks up any new data into a dataset...
Slow PostgreSQL function
Hi, I use this query to select products from my database. Performing this query takes ~0.220ms. If I remove the 3 lines where the number_percentage() function is used everything is fast (~0.07ms or less). SELECT DISTINCT ON (p.id) p.id AS product_id, pv.price, number_percentage(pv.price,t.percentage) AS price_vat, number_percentage...
SQL Searching entries not yet grouped
I have two tables: +------- IPs ------+ +---- Groups ---+ | Id (Int) | | Id (Int) | | IP (String) | | Name (String) | | Comment (String) | | IPs (String) | +------------------+ +---------------+ The IPs-column of Groups is a comma-separated list of the IPS that this group consists of (The Id of the IP in the IP...
how to apply particular FORMAT of date of birth in sql Query?
suppose i want the particular format of date of birth as (mm-dd-yyyy) ...
Count All incomplete SQL Transactions running on database ?
Hello, I need T-SQL to count Count All incomplete SQL Transactions running on database in another way I need to count all current sql transactions runnging right now on sql server instance. I hope if I explained well what I need ? thanks. ...
what's the usage of named pipes ? can I connect from management studio using a named pipe ?
at the moment I turn on the TCP/IP in sql server network configuration and enable the ip used for connection after I'm able to connect using management studio I saw that there is also an option to connect using named pipes, but I could succeed to connect from management studio using the pipe name ...
How to implement a cross-database foreign key constraint?
Let's say I have two schemas: HR and Orders. [HR].Employees [Orders].Entries -------------- ---------------- Id_Employee ----> Employee Fullname Id_Entry Birthday Description Amount As you can see, what I'd want is to be able to establish a cross-database foreign ...
how to join more than 2 table using sql Query?
suppose i have more than 2 table and i want to join the specific column to be join .for this what is query? ...
PHP Print only select rows for SQL Enquiry Results.
In PHP I am having difficulty trying to extract row data from one SQL Query results. The service information I require is stored in an array called $SelectedItems. The Code below works as it should but Prints the Entire table with all rows. How would I get it to simply print the 1 row. $sql ="select blah blah" //Output result ...
LINQ and joining on selects
I have the following SQL: select o.tekst as Enhet, coalesce(f.Antall,0) as AntallF, coalesce(f.snitt,0) as SnittF, coalesce(b.antall,0) as AntallB from tblhandlingsplan hp inner join tblorg o on hp.eierorgid = o.orgid left outer join (select f.handlingsplanid, count(t.tiltakid) as Antall, coa...
SQL query building practices
I am building a SQL query that dynamically changes based on passed in $_GET parameters. I simply want to know if putting in a 'dummy' constraint is an 'acceptable' practice, so I do not have to check the SQL string for the existence of 'where' before I add new constraints (each time). For example, the 'dummy' constraint': $sql = "sele...
How to read in a text file from a stored procedure
I need to read in a log file created by a SSIS package in my stored procedure. Is there a good way to do this? I tried using this code but it shows the contents of my file as jibberish. Is there some kind of encoding issue it's not handling? Is there an easier way? ...
How to select xml in 1 stored procedure and pass selected nodes as parameters into another procedure
I have a stored proc that does inserts of “people”. I have an xml document with a bunch of people I want to insert. I want to call my stored proc like below and expect the stored proc to be called for each person in the xml. It is telling me that the stored proc “expects a parameter of @Id” and is failing. @Id is the first param and ...
Is it really bad to use * in SQL?
Possible Duplicate: SQL: Using Select * Hi everyone! I wonder if it is really a bad idea to use the * symbol in stored procedure in SQL server? Is really better to write SELECT NAME, AGE, OTHER_STUFFS FROM TABLE than SELECT * FROM TABLE For sure is only 3 columns in the table.. For performances is it better to enu...
How to get individual bytes from a SQL binary field
I have a binary field in SQL Server which I want to read one byte at time in a SQL function. In code I would use a byte array. Is there an equivalent in SQL? I couldn't find anything with google. ...
ms Access import table from file in a query
Hello, Is there a way to have a msAccess DB query import a table from file? ...
T-SQL Filter XML Variable
Hello, I was wondering which one of the following two was the better way of filtering on a column in my xml variable. INSERT INTO [Tracking].[Team]([Name], [Description], [Begin_Dt], [End_Dt], [Update_Dt]) SELECT x.[Team].value('Name', 'varchar(100)') AS [Name], x.[Team].value('Description', 'varchar(250)') AS [Descript...