create a stored procedure without any parameters if you want to perform a specific operation that does not require any input. We create a stored procedure named dbo.GetAllEmployees without any ...
- LoginName: The name of the login associated with the 'sysadmin' role. - LoginType: The type of login (e.g., SQL authenticated, Windows authenticated). - ServerRole: Displays 'sysadmin' as this ...
Ok in MSAccess I can send an SQL string to a server I'm connected to and as I understand it that string can contain anything.<BR><BR>Basically it would behave as if I was connected to the server ...
In this third in a series on working smarter with T-SQL, let's give the built-in sp_executesql stored proc a go. In my previous posts, I've described some methods for generating and executing T-SQL ...
I have a weird issue (well weird to me).<BR><BR>I'm using SSSRS and I'm using multivalued parms so people can select multiple values to pass for a single parameter. (i.e. EntryTypeId and they get a ...
Working with dynamic SQL is all well and good, but avoid the risks that can lead to your code being susceptible to a SQL injection attack. As much as making your T-SQL work smarter for you, a la ...
Though businesses typically use Microsoft's SQL Server for mundane items such as customer names, addresses and sales amounts, you can also store entire PDFs in a database record. Data items called ...
Data developers are still learning about all the new goodies that arrived with SQL Server 2022, which is chock full of new features and enhancements such as ledger for blockchain security. Microsoft ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results