Stack Overflow
Stack Overflow

Questions tagged [dbo]

Use dbo for questions related to SQL Server database ownership of tables, catalogs, schema, or other database objects

References

70 questions
0
votes
0 answers

Creating table with loop through csv file to create columns

I am new to SQL I hope this is an acceptable question. I have a table with these relevant columns: [ID] - this is the id of the data [eventdescr] - a string containing the description of the value AND the value itself among other parameters eg.…
JWAJ
  • 1
  • 1
0
votes
0 answers

How to search a combined cell value with another value (text + text)

First time posting and not a SQL expert by any means! Aim: I want to combine multiple row values (b.[Canvasser Name]) into one combined cell (f.canvassers) and check f.canvasser doesn't contain the same value as aa.[Primary Canvasser]. All of these…
astorian
  • 1
0
votes
1 answer

SQL query for time difference for tracking performance

It is an status-driven application-tracking software. Some of the basic tables in the module are: dbo.Application with columns ApplicationID, FirstName, LastName, Email, ApplicationTimestamp, CurrentStatusID dbo.ApplicationStatusHistory with…
Ritush
  • 39
  • 4
0
votes
1 answer

SQL dbo to Custom Schema migration steps

I need steps to change my default [dbo] schema to some custom schema say [TEST] in SQL Database. I figured out some of the steps and want to make sure is there any other objects or procedure i should be aware of while migrating the schema. I need to…
Joee
  • 1,834
  • 18
  • 19
0
votes
0 answers

How do I back up just dbo and not the entire database in MySQL?

I want to back up only the dbo's and not the entire database in MySQL. Backing up the entire database is easy. You simply right click your database, select "Tasks" -> "Backup" and you're done. However, I do not want to back up the entire database.…
Bman
  • 11
  • 3
0
votes
0 answers

MSSQL DBO User Permission in Plesk with Godaddy

I'm trying to restore a MSSQL database from a backup file (.bak). I'm using Plesk with Godaddy for hosting. Unfortunately Plesk in Godaddy only provides Read and Write permission to MSSQL users. When I'm trying to restore the database using my .bak…
Masudul Hassan Quraishi
  • 1
  • 1
0
votes
1 answer

Azure SQL Database new created user with dbo schema but cannot search the tables under dbo schema

In Master DB: CREATE LOGIN Test_Admin WITH PASSWORD = 'xxxx'; GO CREATE USER Test_Admin FOR LOGIN Test_Admin WITH DEFAULT_SCHEMA = [guest]; --want to grant minimum access rights GO In Target DB: CREATE USER Test_Admin FOR…
DaiKeung
  • 1,077
  • 1
  • 19
  • 38
0
votes
1 answer

PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: parameter was not defined in add_product.php on line 29

Sorry very new to PHP and mySQL. Here is the code there error is referring to. $query = 'INSERT INTO movies (title, year, actor, notes, category) VALUES (:code, :name, :price, :notes, :category_id)'; $statement =…
jriding
  • 1
0
votes
1 answer

My UDF won't work when I try to use it

I am still kind of a beginner here but I created this UDF: USE NorthWind GO IF EXISTS(SELECT name FROM SYSOBJECTS WHERE name='SaleAfterDiscount' AND type ='FN') BEGIN DROP FUNCTION SaleAfterDiscount; END GO CREATE…
Zachary
  • 1
  • 2
0
votes
2 answers

SQL drop table errors

I'm trying to create a database for a soccer registration application. I'm trying to keep it simple right now and once I feel comfortable then make it more detailed. I'm trying to run my sql but I keep getting these errors. I was wondering if…
NoLuckCollector
  • 65
  • 8
0
votes
2 answers

SSMS (SQL) Not recognizing CASE WHEN... jumps to last ELSE 0

For example's sake, this returns an ORDER NUMBER of 55 and Calc_ORDER_NUMBER_LAG of 55, the Calc_Qty_Changed column doesn't give me a 2, even though they are equal... USE MfgMetrics SELECT [ORDER NUMBER], [Calc_ORDER_NUMBER_LAG] =…
mitchmitch24
  • 385
  • 1
  • 7
  • 20
0
votes
2 answers

Microsoft SQL Server Error: "Incorrect syntax near keyword Select"

Unsure what syntax the error is referring to at this statement :- Use MyDatabase CREATE TABLE TestTable AS (SELECT * FROM dbo.MyTable); Any help is appreciated!
mitchmitch24
  • 385
  • 1
  • 7
  • 20
0
votes
1 answer

Why can't a user create tables in a database (they own) with a script? SP permission issue perhaps?

I granted a user permission to create databases. They were able to create a database, which they now own, but they are getting errors when running a script to create the tables. I don't have a lot of information at this point (sorry!), so I can't…
Triynko
  • 18,766
  • 21
  • 107
  • 173
0
votes
2 answers

How do I create an OLEDB table with the column named "DATE"?

We're using the Microsoft Jet OLEDB provider to insert data into a legacy system. This system requires that we insert data by creating a DBF file, which has the format of: employee Numeric (10,0), jobcode Numeric (10,0), date date So, we are doing…
Anthony
  • 167
  • 2
  • 16
0
votes
2 answers

How do I randomly get variables from a mysql database? (using php with dbo connection)

My question clearly states it in the heading, anyway a more elaborate question is how can I randomly show a variable (eg. name) from a mysql database using php with a dbo connection in xampp environment. Here is what I've come up with from…
Jaeger
  • 3
  • 2
1 2
3
4 5