Search:
Type: Posts; User: GaryMazzone
Search:
Search took 0.24 seconds.
-
Remember this saying... You can't make it idiot proof because someone will make a better idiot
-
Username should be unique not password
-
@tg if the user is marked as sysadmin (sa) they get access to all databases no need to add to each DB. I would not put empty string for initial catalog. But something (master,msdb... but something)
-
I prefer Tilt your monitor to the right.... apparently all the screen fonts and forms are falling off the left side of the monitor
-
I run this is SSMS (or an app I wrote):
SELECT
COLUMN_NAME AS [Field Name] ,
DATA_TYPE AS [Data Type] ,
Case DATA_TYPE
WHEN 'char' THEN CASE...
-
The question should be how unique will the values be? Will you be searching more often for a NULL or the not NULL values. A filtered index would should be you best choice, actually 2 of them one...
-
It's a There will always be a better IDIOT
-
I usually just drag and drop it into SSMS
-
Sorry but when consulting I always point out problems with the way a company is handling backups. Everything from not doing proper T-Log backups to relying on something like comvalt (pauses IO on...
-
My complaint on merge statement is purely performance related... It is horrible when ever I used it
-
Learn documentation then ask questions:
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/create-a-full-database-backup-sql-server?view=sql-server-ver15
...
-
In 2 seconds can be bad..... I have to return results in less that 2 seconds with internal time (time spent in our DB) should be under 500 ms. We are in the Credit card processing area
-
In typical DBA fashion .... It depends....
By that I mean is the data type small? Not a problem (probably) Is it large batches of text, A problem .... the problem will be in the transaction logs...
-
If the fields are the same type have you considered using a UNION query:
PSQL = "SELECT [Desc] As Field1, Price as Field2 FROM LineEntry WHERE Desc LIKE '" & mCelContent & "%' ORDER BY [Desc]...
-
Do you have transaction logs for the database? If in full recovery you could use SQL tools to look though them. The default trace might have something if it was not done long ago
-
This works for 2012 or 2014 (and 2008,2008Rs, 2005)
CREATE FUNCTION usp_fnsplit (
@inputVals VARCHAR(MAX),
@delimiter CHAR(1)
)
RETURNS @output TABLE (splitval VARCHAR(MAX))
BEGIN...
-
How I see development going most of the time (I still see this now)
User: Bring me a rock
Developer: OK here is a rock
User: Yes it is a rock but just not the rock I was looking for. Bring me...
-
Powershell will work also
-
I would do a Cast(RecieveDate AS DATE) No need to convert to string
-
One other thing to remember in SQL Server blob storage is not in line (meaning not on the row) so it required extra IO anyway.
-
You need a column added to the table along with the function. Each user would need something.... i.e. the app can still be the .Net user but a user needs to log in with their own credentials. Those...
-
As I said that is possible using Row-Level security in SQL Server 2016 and up. You write a function that is used when you access a table that basically adds a where clause to you query. You can see...
-
Did you check the users table in MySQL? There is a host column is that location in that column for that user? You can use % in the host column also (that would mean anywhere)
-
There is no SQL Server Version 18.9.1 that is an SSMS version and has nothing to do with the SQL Server version.
-
It is on the row. the function acts like part of the where clause (automatically added) . It is a bit of a pain to setup especially if the tables already exist and you are trying to add it to...
-
There is row level security in SQL Server (from 2016 on). It requires functions created and using those function on a call to the select statement. If the function says you have access you see the...
-
When I was developing CR reports for use in VB (or .Net) I always developed them in CR and just used them in the app.
-
I believe it formats to the default/ selected printer
-
I have no idea why yours run slowly I can do that over tables with 10,000,000 rows and get good speed.... If you are running MS Access that is not the fastest database there is. The second one down...
-
Another way
INSERT INTO TABLE1 (field1,field2,field3)
SELECT
t2.field1
,t2.field2
,t2.field3
FROM table2 t2
-
If a record exists in table 2 and not in table 1 there is no way to update table 1 it is not there..... If it exists in both table 2 and table 1 then you can update. If it exists in table 1 and not...
-
We will need more info than you have supplied here... What is the database? Where do the tables exist? Does your DB support the MERGE statement? As say more info
-
You can't update rows that do not exsist in the table already....
You need to do an insert to the table where not already in place...
-
You create the SQL login. You grant connect to the database you want then only grant execute on the stored procedure you want that login to be able to execute..... If it is all SPs in the DB you can...
-
I would just grant execute on the procedures to the user you want.
-
I would use a BETWEEN clause ( WHERE ID BETWEEN (X and Y) )
-
We also include a parameter value for AND name @OR as a BIT is it is 1 then we set all parameters to OR if 0 set to AND
-
We do that in our app... unfortunately we need to use dynamic SQL to build it. There are a lot of parameters that we pass into the SP (they can be null). The front end allows the user to select...
-
Truncate table should work with most DB systems that follow the ansi standard.
-
Zvoni DON"T do DROP and CREATE for the table the better option would be (if not the Parent table in a FK relationship) to use TRUNCATE TABLE schema.tableName. this will also reset identities to 0...
|
Click Here to Expand Forum to Full Width
|